check for duplicates

[Josh Armstrong]

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

[TC]

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.goo gle.com...

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

[Pieter Linden]

jo***********@s ocal.rr.com (Josh Armstrong) wrote in message news:<b6******* *************** ****@posting.go ogle.com>...

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

If the two fields (LinkSysNum,Sys Num) comprise, the primary key, then
you *cannot* add duplicates. Why not make use of what the database
will do for you instead of making work for yourself?

[Josh Armstrong]

> > 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

If the two fields (LinkSysNum,Sys Num) comprise, the primary key, then
you *cannot* add duplicates. Why not make use of what the database
will do for you instead of making work for yourself?

I thought about that, but the 2 fields do not make up the primary key.
I was not able to do that as it is set up such that
Record A is linked to Record B
If you look at Record B you will see A and vis-versa

If you Start will B and add the Link to A then you now have a dupe
record.
AB
BA

I need to check for both before saving the new record.