Updating sum calculated field

[bid19123]

I have a form containing a subform. The subform sums the individual counts which are then shown in a textbox on the main part of the form. The problem is that to get the sum value to update I have to move to the next record in the main form and then return to the original record. The mainform is based on a query and I suspect I have to write some code to rerun the query. Could someone please give me an example of the code needed and also tell me where the code should be placed (on dirty, afterupdate etc).

Thanks

Alan

[ranman256]

in the subform footer, but a text box that sums the sums: =sum([sumFld])
this box should always be live and not need updating.