subform assistance needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top