If, Then Statement

[rgeinosky1]

After I received your kind replies, I realized I was not clear at all with my question. Please allow me to try again. I have a form with a subform. The form is populated with the tblMaster table. The subform is populated with the tblPersons table. The 1st statment works fine. It is attached to the "On Lost Focus" of the [Date Closed] field which is in the tblMaster table and gently reminds me to enter the [Status] if I have not already done so.

Both the [Date Closed] and [Status] fields are in the Master table.

1st statement:
If Not IsNull([Date Closed]) = True And IsNull([Status]) = True Then
MsgBox "You failed to enter the Status into the Master File"
End If
----------------------------------------------------------
I am trying to attach the below statement to the "Before Update" event of the form to remind me to enter data into the tblPersons table if I have not already done so. My question is, How do I identify the [Date Closed] field as a part of tblMaster and identify [LName] as part of tblPersons.

The below attempt did not work. Any help is greatly appreciated.

Bob
-----------------------------------------------------------
tblMaster tblPersons
If Not IsNull([Date Closed]) = True And IsNull([LName]) = True Then
MsgBox "You failed to enter the Lname into the Persons File"
End If

 

[PHV]

Take a look here:

http://support.microsoft.com/?kbid=209099

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

 

[rgeinosky]

Thank you PHV

The article which you directed me to solved the problems.

Again Thenks

Bob