HIDE/UNHIDE SUBFORM

[FRANK]

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

 

[Alex Dybenko]

yes, i think

in check box afterupdate proc:

me.subformcontrol.visible=me.checkboxwithswitchvisibilityofsubform

 

[John Spencer (MVP)]

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.