How to update subform dsum field from other subform

[s@s]

Hi all,

So i got a Customers form.

inside it, i got a subform with services-provided.

under the first subform, i have a second subform with service-payments "linked" with the first subform.

one of the fields of services-provided is dsum on amounts from the service-payments



what i would like to do is when i update a field in the second subform to recalculate the dsum field indide the first subform.

i tried something like

[Forms]![frm_service-payments].txtPaymentsTotal.Requery

inside the AfterUpdate() of the service-payments field but im getting an error 2465

any ideas how to do this?

thx!

[pbaldy]

The syntax changes when the form is used as a subform:

http://www.theaccessweb.com/forms/frm0031.htm

[s@s]

ah yes better now, it kinda works, need to fine tune it a bit as it behaves strange. when i update the value in the second subform, the dsum field gets blank. when i go to the next record then it recalculates correctly...