displaying calculated total field from subform in main form

[bkrasnof]

Hi, in access 2003 forms:

I have a =sum([extendedprice]) textbox in my subform footer. I can
display it ok in the main form, but I'm having trouble updating it
after all of the appropriate events.

I have some code in afterinsert and afterupdate events of the subform,
but I'm wondering if there's a better event that would get fired after
any change to a row in a subform, even deletes.

thanks,
Bruce

 

[John Vinson]

I have some code in afterinsert and afterupdate events of the subform,
but I'm wondering if there's a better event that would get fired after
any change to a row in a subform, even deletes.

The subform's Current event fires whenever you move to a new record on
the subform. The AfterUpdate event should cover pretty much everything
though!

John W. Vinson[MVP]