In the contact Template they have the -Possible Duplicate- feature I wanted to expand on that. Here is the code:
=IIf(DCount("*","[Contacts Extended]","[ID]" & Nz([ID],0) & " And [Contact Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"-Possible Duplicate-","")
I want it to search more then just the [Contact Name] field to find a possible duplicate. I wanted to have it also check [Customer],[Client], and [User] for a possible duplicate. and If the name is a duplicate in anyone of those fields then it would return the -Possible Duplicate- other wise remain blank.