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