Comparing form field with the field from database

[np1111]

Hello.

I have another problem with access. I would like that one of my buttons will check before he saves my fields into the database if in the database already exist this field. I add a condition to button:

IIf(([Forms]![ZNC]![C_1])=([dbo_KRT]![C]);1;2)

and if it is correct prompt by window with error.
I think that it didn't check if the field exist in the database.

This isn't work!! please help

[pbaldy]

The simplest method is probably a DCount:

If DCount(...) > 0 Then

more info on the syntax here:

DLookup Usage Samples