Another duplicate thread - with a twist

[bbznyc]

Here is another one for you guys...

I have a form which feeds the table, standard setup - autoID, LName, FName, and 19 other fields with text/number variations about an employee and similar info about employer.

I want to know if there is a duplicate entry being made. There are quite a few people with same first and last names. I want to be able to differentiate them by their address only (no phone number). Problem is when i tried to find some information on this, I only encountered code for the BeforeUpdate_Event, however, I already have VBA code there for "making changes Yes/No"

Also, I just want to warn the user about this and if there is a possible match - take the user to that particular contact, this way they can be sure if its the same person.

Please guide me into the direction I should take.

Thanks again everybody,

 

[WayneRyan]

Hi bb,

You can use the form's BeforeInsert event and the DLookUp function to
look for a duplicate record (and cancel the insert).

BUT, if you have an AutoNumber field, the record may be already committed
before you have a chance to look.

Depends ...

Wayne

 

[bbznyc]

Is there another way I do a "Save changes" ??? This way I can implement the BeforeUpdate event.

Thanks,

 

[bbznyc]

anybody got an idea?