I'm presently trying to aggregate (sum) data from and store this in the main form as the data is updated in a subform.

Similar to a running total in an order when order lines are added or volumes changed.

I understand the events to trigger the activity but haven't been able to get it to work accurately.

I've tried the 'aggregate' function but can't get it to work with the data in the 'live' form.

I've tried simply adding the row value to the total value in the main form but this only succeeds in double adding if you make a change (e.g. to volume)

I'm sure there is a solution and would appreciate any help.

Thanks

Gareth.