Displaying a 'matching record' message when entering data

[lsmcal1984]

Hello,

I have a consultation database where users enter data from a variety of sources, that may lead to the same person being entered twice (under different IDs of course).

Is it possible to display a message such as "one record with this name" when a first and surname has been entered onto a form? I have attached a picture to show what I mean.

I am hoping the user would then search for the matching record (or open it in my record print function) and check if the person has already been added to the database.

Any improvements/suggestions also welcome.

Many thanks,

Leo

 

[John Big Booty]

You could use the DCount() function in the before update event to check if a record already exists with the same given and family names.

Why not select your clients from a combo, that should go quiet some way to eliminating double entry of the same client.

 

[jdraw]

Names alone are not a great solution for checking for duplicates - especially John Smith example. If you have other characteristics for the Person (in addition to Name) such as Postal Code, City, Phone - you could include these when checking for duplicates.

As John said, DCount(...) >0 is a method for finding potential duplicates in the Before Update event.