subForm Visible problem

[Bob Vance]

lblFoaling works fine but I cant get tbDate to work as it is in the sub
form of my form!
Me.[lblFoaling].Visible = Not IsNull([tbBirthDate])
Me.[lblMemo].Visible = Not IsNull([subformAlerts.tbDate])

 

[Bob Vance]

Thanks Ken, nearly got it right Regards Bob

Bob:

Your bracketing is wrong:

Me.[lblMemo].Visible = Not IsNull([subformAlerts].[tbDate])

Although not absolutely necessary I'd usually include the Form property
when
referencing a control via a parent form's subform control:

Me.[lblMemo].Visible = Not IsNull([subformAlerts].Form.[tbDate])

Ken Sheridan
Stafford, England

lblFoaling works fine but I cant get tbDate to work as it is in the sub
form of my form!
Me.[lblFoaling].Visible = Not IsNull([tbBirthDate])
Me.[lblMemo].Visible = Not IsNull([subformAlerts.tbDate])