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,
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.
 
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
 
You must log in or register to reply here.

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
Make Calendar Control Invisible 1
SQL Statement wording 2
Make a form field invisible 2
mirror data from subform to main form 3
Open main and sub form blank 1
Link subform ID control 3

Back
Top