how to use IIf statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top