Say the user types the potentially duplicated value into a textbox.
Use a DLookup() function in the BeforeUpdate event of that textbox. If the
DLookup() finds an exsting record, it can display a message using the
Msgbox() function, then set the Cancel parameter for the BeforeUpdate event.
This will stop the form accepting that value.
HTH,
TC
"Josh Armstrong" <jo***********@socal.rr.com> wrote in message
news:b6**************************@posting.google.c om...
I need a form to check for duplicates before a new record is added.
Table name: Links
Field1: LinkSysNum
Field2: SysNum
For example, [LinkSysNum]=539 is linked to [SysNum]=540
[SysNum]=544
The db is setup using a union query to cross link the records. The
form needs to be able to look at the record it is about to create and
if it finds that it is already there give a msg.
Thanks