Checking for duplicate ID numbers

[hwmueller]

Hi

I have a database where users choose subjects for their course and identify themselves by means of their unique student ID. This number acts also as the primary key. How can I write code that checks the student details table to ensure that the ID in question hasn't already been used?

Thanks

Hans

 

[braindead2]

set the tables index to no duplicates and it will do that for you.

Or Dlookup, or a query or .findfirst .nomatch etc...