I have a form that 15 people are using. Each person opens the form and then reviews the first record. The problem is that we don't want 2 people reviewing the same record. Each record contains a number that should only get reviewed by only 1 reviewer. There is a "Next" button that writes the data to another table when the review is done reviewing the information. If 15 reviewers are in the same form, we don't want a record being reviewed 15 times. I implemented the RecordLocks Property but this isn't enough for the user. Any suggestions?

Thanks.

Kim

You need to add a 'BeingReviewed' field to the table. Base the form on a query which only selects 1 record which is Not being reviewed (use a Top 1 query) . In the form_ current event procedure update the being reviewed flag and save the record. After you have written the reviewed record in your Next button, requery the form to get the next record available.