subForm Visible problem

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])
 
B

Bob Vance

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top