Need HELP! Pulling a RANDOM record from table to form

[asmith78]

HI All,

I have an Access 2003 database built for a quality program (I know, way behind on the version, we are currently upgrading to 2010 now). I have a "sample" table where we load all the files for a group. We then have an "audit" form where we try to pull a random record from the "sample" table to perform the audit then add the info to the "audit" table and the code updates the record on the "sample" table to complete.

I thought we had the code all figured out but if several auditors are working on the same group, it will pull the exact same audit. It seems this is happening when they click on the "Get Audit" button within seconds of each other.



I am attaching the code behind the "Get Audit" button that runs the module to pull the random file. If you need any additional info, please ask. Thanks for looking!

[hertfordkc]

http://office.microsoft.com/en-us/ac...001228901.aspx

I didn't see it in your code and I think it might help.