Hide Subform with command button

Question

Access 2010, Win 8

I have a form "ResourceForm" that has a command button "More Details" to make a subform visible. Once the subform, "ResourceCSubform" is visible, it has a command button "Close" to make it un-visible.

I have tried:

Me.Visible=False

and

DoCmd.Close, "ResourceCSubform"

in the OnClick of the "Close" command button but it does NOT work.

Can you offer some code or method that will hide the subform with a button click??

Thanks,

Max

Answer 1

You first have to move focus from the subform by setting it to any control in the parent form.  You can then hide the subform control:

    Me.Parent.cboOffice.SetFocus

    Me.Parent.ResourceCSubform.Visible = False

where cboOffice is the combo box in your parent form, and ResourceCSubform is the name of the subform control, i.e. the control which houses the subform.  This might or might not be the same as the name of its source form object.