I have following to check if a contact already exists,
If DCount("*", "[tblCustomers]", "[Surname]= '" & Me.Surname & "' And [First name] = '" & Me.First_Name & "' And [Company Name] = '" & Me.Company_Name & "'") Then
Beep
MsgBox "This name already exists in the database!" & vbCrLf & " Please check for duplicate entry.", vbExclamation, ""
Me.Undo
however there might be the possibility that a person can be called the same at the same company. I need to run a check to keep duplicate records down to a minimum.
After discussion with the end user they wondered the following
When the message comes up to say "this is a duplicate" can it then go on to show you the record it already has and ask if changes are to be made. This allows the inputter to see the existing record and decide whether it is the same person. If it isn't the same person, they can see how this one is inputted and maybe input the second person slightly differently. I.e. if first record is for Mr. Mick Adams - the second person with the same name could be inputted with their middle initial - Mr. Mick. J. Adams
What do people think about this If so how would i go about this?
If DCount("*", "[tblCustomers]", "[Surname]= '" & Me.Surname & "' And [First name] = '" & Me.First_Name & "' And [Company Name] = '" & Me.Company_Name & "'") Then
Beep
MsgBox "This name already exists in the database!" & vbCrLf & " Please check for duplicate entry.", vbExclamation, ""
Me.Undo
however there might be the possibility that a person can be called the same at the same company. I need to run a check to keep duplicate records down to a minimum.
After discussion with the end user they wondered the following
When the message comes up to say "this is a duplicate" can it then go on to show you the record it already has and ask if changes are to be made. This allows the inputter to see the existing record and decide whether it is the same person. If it isn't the same person, they can see how this one is inputted and maybe input the second person slightly differently. I.e. if first record is for Mr. Mick Adams - the second person with the same name could be inputted with their middle initial - Mr. Mick. J. Adams
What do people think about this If so how would i go about this?
