Change a Subform Visibility from a click

[Guest]

Here is what I want to happen. I would like to use a list box, lstUpdate, to
change the visibility of subforms hidden on a page.

The list box is populated from a table, tblClickOpen, with 2 fields Title,
and Form.

I can open a form from the double click of the list box, thanks to Ofer for
helping me there, but I would like to keep the subforms in the same location
and just make them visible when I need them.

 

[Guest]

Set the Visible property of the subform to "No".

Then on the event you choose (i.e., the double click of the list box) add
code to the event to make the form visible. Examples:

Forms!frmHiddenSubform.Visible = True

Me.Child19.Visible = True

Don't forget to add code that "hides" the subform when you are finished.

Let me know if this helps.

 

[Guest]

Just what I needed. On the single click in the listbox I hide all the
subforms. That way, on the first click the forms "disappear". On the second
click the subform opens. Very helpful. Thanks Randy