Warning when add new record with duplicate primary key

[Song]

I have a form to add new record using navigation button at the bottom. When
fill in all the fields, Access would give a nasty warning message when stID
(primary key) is already exist.

I need code that when user enters duplicate value in stID (which is the
first control on the form), it would be notified such stID already exist and
would locate the existig record and display on the form.

 

[Guest]

Check this link on "Preventing Duplicates from being entered"

http://www.databasedev.co.uk/duplicates.html

 

[Song]

It works great! Thanks.

Check this link on "Preventing Duplicates from being entered"

http://www.databasedev.co.uk/duplicates.html