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.
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.
Show what you have tried.
http://access.mvps.org/access/forms/frm0031.htm
You set the Visible property of the control to True.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
The problem is it doesn't recognize the subform name. How do I know what the subform control is?Code:Me!Subform1.Form!ControlName.Visible = True
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.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba