Replacing of Running Total from Subform's control to Main form's table's field

[A Y Khan]

Respected Fellows:

I have an access form (Customer) along with a sub-form (Work_done). On sub-form I have Running sum of Amount in Text box-1. I want that Total of Running sum be replaced with Main form's tables field total_amount. Is it possible that we can replace an amount of control of sub-form into main form's field?

[June7]

Saving aggregate data to table is usually a bad idea. Aggregate data should be calculated when needed.