subform assistance needed

J

JohnE

I have an issue of referencing a subform to make it visible. The subform is
on a subform that is in a subform on a main form. Confusing, I know. But
this is what the users wanted. What you see below is the progression
starting with the main form and ending with making a subform visible. I am
at a loss as to where the bangs (if any) or the word Form(s) goes, or if this
is too deep. The button that is to make the subform appear is on another
subform located on frmVehicle.

frmHomeInformation.ChildSubforms.frmVehicle.sfrmVehicleMaintenanceCommentSubform.Visible = True

Any assistance is appreciated.

.... John
 
A

Allen Browne

John, you omitted the .Form bit that refers to the form in the subform
control, like this:

Forms!frmHomeInformation!ChildSubforms.Form!frmVehicle.Form!sfrmVehicleMaintenanceCommentSubform.Visible
= True

Explanation in:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html
 
Top