Referring to other fields in a table from a form

  • Thread starter Thread starter Lurch
  • Start date Start date
L

Lurch

Hi There!

I have a form (Form1) that when opened I want it to look at a couple of
fields in another table.
I want it to:
determine if field1 on Form1 is equal to a field in a table. Then I want the
Form1 to determine if another field in that table is null. If all this is
true then I want field1 in form1 to have a red background otherwise I want
it blue.

I've tried 'if' statements but I just can't get it to work...

Can someone help me?

Thank you VERY much
 
Check out the DLookup function in Help. It lets you "look up" the value of a
field in a table or query, and you can specify the "WHERE" conditions as
well.
 
Back
Top