Is it possible to hide/unhide a subform on an active form?
I would like to click a check box to make it visible or
uncheck the box to make it visible.
Thanks.
Frank

yes, i think

in check box afterupdate proc:

me.subformcontrol.visible=me.checkboxwithswitchvisibilityofsubform

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com



"FRANK" <(E-Mail Removed)> wrote in message
news:092201c3581d$0e200060$(E-Mail Removed)...
> Is it possible to hide/unhide a subform on an active form?
> I would like to click a check box to make it visible or
> uncheck the box to make it visible.
> Thanks.
> Frank

Sure the subform control has a visible property so in the form's code module you
would need

Me.NameOfSubformControl.Visible = Not(Me.CheckboxName)

I would put that code in the after update event of the checkbox and, perhaps, in
the on load event of the form.

FRANK wrote:
>
> Is it possible to hide/unhide a subform on an active form?
> I would like to click a check box to make it visible or
> uncheck the box to make it visible.
> Thanks.
> Frank