Prompt to advise of duplicate entry

[Guest]

I am using Access Data Project with SQL backend and have a table of parts
with serial numbers. In the parts entry form, if someone enters a part with
a serial number that already exists in the table, can the user be prompted
'Serial Number already exists'?

Thanks.

 

[[MVP] S.Clark]

Yes. In the AfterUpdate, query the table for an existing SSN. If True,
then MsgBox, else don't.

Inquire within the FormsCoding newsgroup for specific help on the coding of
forms.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html