make sub form invisible until field in main form populated

D

deb

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

Thanks,
 
P

pietlinden

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.
 
L

Larry Daugherty

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
 
Top