Check for duplicate records based on mulitple criteria

H

HelloWorld

Hello .

I would like to be able to look for duplicate records that look at the first
and last name of a record for criteria. that data is in the [Applicant Data]
table in two different fields called [First_Name] and [Last_Name]. the
datatype of both fields are text

I need to do a check to see if a record exists and then if it does pop up a
msgbox that allows a user to either, if yes is chosen, continue editing that
record. Or if no, cancel out and clear that records existing data.

please adivse as to how I could get this done.

Thanx
 
Top