Tree subforms in a form

[ReidarT]

I have a form with 3 subforms. How do I change recordsource on subform3
after update of combobox on subform2
Mainmenu
SubForm1
SubForm2
SubForm3
Forms!MainMenu!SubForm1.Form!Subform2.Form!SubForm3.Form!RecordSource =
"tblTableName" ???

reidarT

 

[Douglas J Steele]

Is SubForm3 on SubForm2 which is on SubForm1, or are all 3 subforms of the
main form?

Are SubForm1, SubForm2 and SubForm3 the names of the controls that hold the
subforms, as opposed to the names of the forms that are displayed in that
control (Access defaults them to the same name, but some people change
them...)

If you picked the first choice for both questions, then

Forms!MainMenu!SubForm1.Form!Subform2.Form!SubForm3.Form.RecordSource =
"tblTableName"

should work (the only difference I have above is that I used .RecordSource,
not !RecordSource)