Duplicate record error message

[pd06498]

I have a table in my database set up so the user cannot enter duplicate records.

When I test the associated form and try to enter duplicate records, I get a message after clicking the next or new record button that I cannot go to the record. This, I assume, is Access' error message for this problem.

Could someone be so kind as to show me how to create an error message that will deliver the message, have an OK button, and refer the user back to the offending duplicate field?

Thanks...

 

[dcx693]

A quick search pulled this up: Duplicate value messageJust use the SetFocus method to move the cursor to the offending field.