make sub form invisible until field in main form populated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make a subform invisible until the Project Field on the main form
is populated?

Thanks,
 
How can I make a subform invisible until the Project Field on the main form
is populated?

Thanks,

In the OnCurrent event, set the subform's visible property to False.
Then in the Visible property of subform in the AfterUpdate property of
the project field on the main form.
 
Set its "visible" property to False. When you want it seen again, set
it to True.

There's a pretty good paper by Keri Hardwick on referring to subforms
on www.mvps.org/access

HTH
 
Back
Top