Record already exists

[PeteJM]

Hi, I have a database that stores name and address details in a table.

There have been some data entry errors where a name has been entered twice. I can't make Firstname & Surname primary keys because there are occasions were some people with have the same name.

What i'm looking to do is when a Firstname & Surname have been entered into the database there will be some check preformed to let the user know that a record with thoose details exists, and give an option to View the duplicate record or continue adding the new record.

any ideas if this will be possible?

Regards

Pete

 

[ghudson]

Use the DCount() function to test if the first and last name exist. If the value of the DCount > 0 then they exist. Search the Access help files or this forum for how to use the DCount() function.

 

[wkalo]

Search The help In Access On How To Use The Wildcard Search....

I Think This Would Answer Your Question
Good Luck