If, Then - Related tables

[rgeinosky1]

I am having a brain block. The first If, Then statement works. It uses one table. The second one is using two tables. Do I enclose them in [ ]. I've tried that but must be doing something wrong. Help please
-----------------------------------------------------------
If Not IsNull([Date Closed]) = True And IsNull([Status]) = True Then
MsgBox "You failed to enter the Finding into the Master File"
End If
-----------------------------------------------------------
tblMaster tblPersons
If Not IsNull([Date Closed]) = True And IsNull([Status]) = True Then
MsgBox "You failed to enter the Finding into the Master File"
End If
-----------------------------------------------------------
Thanks
Bob

 

[PHV]

No one of your statement should use table, but Control.
Can you please elaborate on what your issue consists ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[frobo]

try to have these table fields on the form with the same (this is table field) name and probably hide it from user and color it red to see clearly in design that it's hidden.

So Your code should/could possible work then.

hope it helped

 

[Ascentient]

Would it not be easier to set up two record sets? then reference them that way?
Dim Db as CurrentDatabase
Dim rsMaster as Dao.Recordset
Dim rsPersons as Dao.Recordset

<open Tables>

<Locate Records>

<Your Code with rs References.)