totals within subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I have a subform based on a query. The query has a calculated field based on
fields in the query, e.g. total = item * price. There are a number of records
in the query. What I would like to do is display the total of the calculated
field in the main form and add it to another value. I have put a hidden sum
in the footer of the sub form. This calculates the total, but does not update
if I change a value in the query, e.g. the number of items. Can anyone help ?

Thanks
 
the unbound textbox control in the subform's Footer section will update
automatically when you move to another record in the subform. if you want to
force an immediate update without moving to another record, you can write
the changed data to the table by adding code to the AfterUpdate event of the
(for instance) "number of items" control in the subform, as

Me.Dirty = False

or

DoCmd.RunCommand acCmdSaveRecord

hth
 
Back
Top