how to use IIf statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerald - 09 Apr 2005 09:37 GMT

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

Reply to this Message

Steve Schapel - 09 Apr 2005 10:12 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> Hi All,
>
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message