Error keeps flashing

[dniezby]

Could someone look at this and help me understand what is going on?



I'm modifying the template "Tasks" and on the Contact Details page there is a TextBox with this code in it.

=IIf(DCount("*","[Contacts Extended]","[ID]<>" & Nz([ID],0) & " And [Contact Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"Possible Duplicate","")

When the form is loaded in live or layout view, it just blinks red and says Error...? I can't fined any references to these fields that might cause this issue.

[ranman256]

you cant replace in an IF.
Run an update query, put the 'if' in the criteria to make your replace.

[ssanfu]

Actually, you can use the Replace function is an IIF() function.

I don't understand your criteria, but this does not error for me:

=IIf(DCount("*","[Contacts Extended]","[ID]<>" & Nz([ID],0) & " And [Contact Name] = '" & Replace(Nz([Contact Name],""),"'","''") & "'")>0,"Possible Duplicate","")

What is "ID"? Usually a field named "ID" is a PK field which is unique. There would only be 1 record.
And why are you using "<>" (not equal to)????? To find "Possible Duplicate", I would think you would want to use "=" (equals).