how to use IIf statement

G

Gerald

Hi All,

Under the Properties>>>Control Source for field Test under table 2
this is what I have given

=IIf([table1]![field5] Like [field4],"OK","CHECK")

What I need is that it should check if both fiedd from Table 2 and Table1 is
= if yes should allow me to continue or stop and allow me only to enter the
notes

Appreciate if anyone gives me the solution

Thanks
 
S

Steve Schapel

Gerald,

I think for anyone to give specific help, they would need to know the
relationship between Table1 and Table2, and some more information about
field4 and field5 would also be good. Examples would help, as would
more meaningful names for the tables and fields.
 
Top