Making control visible in subform

[matey56]

Hi all,
I have a control that is hidden in a continuous subform that I want to make visible when the Add Record button is clicked on the main form. What's the syntax for that? Nothing I try seems to work.

[Welshgasman]

Show what you have tried.
http://access.mvps.org/access/forms/frm0031.htm

You set the Visible property of the control to True.

[matey56]

Me!Subform1.Form!ControlName.Visible = True 

The problem is it doesn't recognize the subform name. How do I know what the subform control is?

[Welshgasman]

You look at it in design view?
Click the edge of the subform, that should highlight the control with parent/child links etc.
If you used the wizard it would be the same name as the subform. I always renamed mine.

[matey56]

You look at it in design view?
Click the edge of the subform, that should highlight the control with parent/child links etc.
If you used the wizard it would be the same name as the subform. I always renamed mine.

Ok I finally got it. Thanks!

[Bulzie]

Just for reference you cannot reference a subform with the Me!, you need to put in the actual name of the main form so like frmMain!Subform1.form!ControlName.Visible = True

[Welshgasman]

Just for reference you cannot reference a subform with the Me!, you need to put in the actual name of the main form so like frmMain!Subform1.form!ControlName.Visible = True

You can with Me. though?