Sum on subforms not refreshed

[sedighahmad]

I have a form whith a sub form .in master form i have a field that show sum of fields in sub form.when if filter in subform that change count of records in subform but dont chaneg field in master form .help!!!!!

 

[souldude]

Create a procedure on the subform's "afterUpdate" event that will refresh the parent form.

Private Sub Form_AfterUpdate()
Forms!MasterForm.refresh
' or Forms!MasterForm.requery
End Sub

-Souldude