reference a Subform from Another Subform

[ddrew]

Hi, I have two subforms on a Main from. I need to reference one from the other to requery it.
Ive tried this, but it dosent work:

Me.Parent.frm_Main!frm_Subform2.Requery

Can someone put me right please

 

[speakers_86]

Try this

me.parent!frm_subform2!form.requery

I think that will work. I'm not entirely sure about the bangs and dots though.

 

[ddrew]

Nope, that didn't work!

 

[hfrupn]

I use this with good results
[Forms]![frmParent]![frmSubform2].Requery

If you have a parent form with multiple sub-forms use a separate line for each form to be re-queried, e.g.
[Forms]![frmParent].Requery
[Forms]![frmParent]![frmSubform1].Requery
[Forms]![frmParent]![frmSubform2].Requery

 

[ddrew]

Thanks, that did it.