Hi All
Long time since I posted here!
Not withstanding the previous replies, may I suggest this or similar may help
- If DCount("[field]", "Table", "[field] = " & Me.Txt_field) >= 1 Then
-
'found it
-
Else
-
'didnt find it
-
End If
As you just need to know if it exist (at least once), I would use DCount() as DLookUp() will return Null if nothing is found. This of course can ne worked round if absolutely necessary.
Above assumes Txt_field is numeric.
I could be totally wrong, but just a thought.