displaying calculated total field from subform in main form

B

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
 
J

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.
Click to expand...

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Display subform total 1
Link subform ID control 3
How to choose a form record based on selection from a subform? 6
Calculated field in main form 4
Use TextBox on the main form to limit SubForm 2
Display "No data" message when subform receives no records from qu 4
Update field on main form, only works when manually step thru code 6

Top