Subform total not refreshing on main form

[dchaff]

I have a subform that calculates a total for amount paid with control named sumDelAmtPd and data is (=Sum([DelvBonusReceived]) where DelvBonusReceived is entered by user. This control is in the subform footer and data is being updated as user updates field in each record. On the main form I want to display this total so that it is updated as the user enter amounts for each record (kind of running total on main form). Main form has this in the text control =[DeliveryPaymentsSubform].[Form]![sumDelAmtPd]. If I update a field on the main form, the subform total displays correctly, but I want to be able to update the main form as the user updates the subform control. I tried multiple ways, and cant seem to get it. Any help is appreciated.

 

[dhookom]

You need to force the save of the record on the subform. You might try code in the after update event of the DelvBonusReceived control.

Duane
MS Access MVP

 

[dchaff]

Tried this to no luck. If I move to previous record, then main form field shows correctly, go back to record I was on when the subform was being edited, the main form display still is not getting updated. Somehow seems I need to change the state of the main forms record, but not sure what to change or how to change it.

 

[dhookom]

How are you attempting to force the save? Moving between records on the subform forces the save.

Duane
MS Access MVP