subForm Visible problem

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

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])
 
Thanks Ken, nearly got it right :) Regards Bob

KenSheridan via AccessMonster.com said:
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

Bob said:
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])
Click to expand...
Click to expand...
 
Back
Top