You can add a random order to a SQL query as you grab the recordset.
See sql - Random sorting query Access - Stack Overflow

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia