Make form visible when closing a form

[carmenv323]

I have my main form (A) and on it I have a subform (B)


On my main form A I have a few buttons to open other forms.

SubForm B is a Request form that i want displayed each time as the default.

When a user clicks on a button to open another form (pop-up C as acDialog) I Hide Subform B so the current form (C) is the only one in display.

The issue is that when I close form C, I can't get SubForm B to be visible again.

On Form C's Close event I have: Forms!SubFormBControlName.Visible = True but it's saying "Object doesn't support this property type or method"

I put the same code on Form A's SetFocus Event but it doesn't do anything either.

[CJ_London]

see this link about how to reference controls on other forms
http://access.mvps.org/Access/forms/frm0031.htm

[Welshgasman]

You would need the mainform name in there as well?
Ajax's link should confirm that.

[davegri]

On Form C's Close event I have: Forms!SubFormBControlName.Visible = True

Try

Forms("FormA").Controls(SubFormBControlName).Visib le = True

FormA is the name of form A
SubFormBControlName is the name of the control on Form A holding Form B

[carmenv323]

This is what finally worked. Thank you

Forms!MainForm![SubForm].Visible = True