Requery a subform

[Guest]

I have a Main form with 2 subforms. One of the subforms, frmSub1 contains
records and the other subform, frmSub2 is a sum of the records in frmSub1.
Each time I update records in frmSub1, I want frmSub2 to requery to post the
new totals. My thought was to add the following code in frmSub1 AfterUpdate
Event:

Forms!frmSub2.Requery

The code errors out saying that the form cannot be found. Where am I going
wrong?

Thanks,

Dennis

 

[Klaus Oberdalhoff]

Hi,

http://www.mvps.org/access/forms/frm0031.htm

should help

 

[ruralguy via AccessMonster.com]

Bookmark Klaus's link. It is a good one. For this reference you can use:

Me.Parent!frmSub2.FORM.Requery

If You wanted to use the Forms collection as you started with then:

Forms!MainFormName!SubFormControlName.FORM.Requery