Referencing a subforms subform.

[nickrugado]

On one(main) form I have a subform(sub1) with a subform(sub2) that I want to requery. Can anyone help me with referencing and requerying a subform?

DoCmd.Requery (reference to sub/subform)

 

[PWise]

docmd.Requery me.subformcontrol.form.subformcontrol.form

 

[nickrugado]

so I can do this...
docmd.requery me.nameOfSubForm.form.nameofSubFormssubform.form and put that on an on click event on the Main form that houses the sub and subsub form?

 

[PWise]

try it you'll like it

perhaps

me.subformcontrol.form.subformcontrol.form.requery