Error in Code Box

[markjohnson]

Hi,

I have a database that lists people that contact me.

I want to know if people contacted me before, so i creted this code that is linked to the "Full Name" Field in my table...

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

So if that person X has contacted me before, it shows the message **Possible Repeat Contact**

I want this to show more or less instantly when the name is entered, but it is not - is this normal, or am i doing something wrong?

Thanks