Trapping Unique ID

[MSAccessUser]

I've a form in which one of the fields the user enters is supposed to be a unique id. The unique id is an alphanumeric text box.

However, it's possible that another user enters an id that has already been previously used.


I'm thinking that I need to run a Find Duplicates Query with the text box entry and a table that holds all the previously entered ids prior to the form being saved so that I can inform the user of the possible duplication.

My question is are there any ideas on how I can do this or code it?

Thanks

 

[RuralGuy]

Why not just set that field in your table to indexed (no duplicates) and let Access and your error handling take care of the problem. 3022 is the duplicate value error to trap for this situation.

 

[MSAccessUser]

That would work. Thanks!