make sub form invisible until field in main form populated

G

Guest

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,
Click to expand...

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
 

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

Similar Threads

Refreshing main form from the subform 1
Problem with form--subform 5
SQL Statement wording 2
Make Calendar Control Invisible 1
Make a form field invisible 2
mirror data from subform to main form 3
Toggle Button 1
Link subform ID control 3

Top