Referring to other fields in a table from a form

[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

 

[Ken Snell]

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.