referencing a control on a subform list in a navigation form

[jex57]

hi All,
I have a navigation for 01 Main

On the navigation form, I have a subform FrmSocialGraph

On the FrmSocialGraph I have a Subform FrmSGUsgage - which has a list box on it. From the list box I need to pass a value to the textbox on FrmSOcialGraph.

My code looks as follows:

Private Sub Systemlist_Click()




Forms![01 main]!frmsocialgraph!SystemLookup = Forms.[01 main].frmsocialgraph.FrmSGSystems.Form.Systemlist.Column(0, Me.Systemlist.ListIndex)
DoCmd.OpenQuery "QrySocialGraph_systems"
End Sub


Prior to putting the form onto the navigation form everything worked.
However since trying to reference it through the navigation form, I get an error

OBJECT DOES NOT SUPPORT THIS PROPERTY OR METHOD.

Does anything know how to fix this?
appreciate the help.

Thank you

 

[Micron]

a form put on to a navigation form becomes a subform. The subform gets a default name of NavigationSubform, so unless you actually changed it, try this syntax for a form on a nav form:

Forms!NavFormName.Form![B]NavigationSubform[/B].Form.ControlName

But I think you're trying to get to one lever deeper on a subform of the form on the nav form? Maybe

Forms!NavFormName.Form!NavigationSubform.Form!SubformControlName.Form.ControlName

where NavFormName is the name of your navigation form and subformcontrolname is the name of your control that contains your subform (might be the same name as the form it contains):

Forms!NavFormName.Form!NavigationSubform.Form!FrmSGSystems.Form.Systemlist.Column(0, Me.Systemlist.ListIndex)

as long as the code is on the same form as the listbox, otherwise you can't use Me.

Forms. should always be Forms! not Forms.[01 main]

Not sure where 01 Main belongs in the hierarchy, so I didn't try figuring out your nav form name. FWIW, starting object name with numbers is not a good idea. Plus, names should not contain spaces, numbers or special characters (save for possibly the underscore _).