copying information from a subform to a main form

[potts]

Ok.
I have a subform based on a query that has a calculated field (Charge=[cost]-[discount]). What I need to do is total the charge and store it in a table which is the basis for the main form. what is the best, or any, method of doing this?

 

[Rich]

Best way is not to store it at all, calculate it as and when required

 

[crich21]

same problem

I am trying to accomplish this same task for this reason. My mainform is a continuous form that I need to be able to view the total on hand amounts for each record. then I have a subform that does the individual calculations. But if I don't store the values in a table then the main form will only show the correct total when I am on the current record. Hope this makes sense. I can't rely on the subform for the values everytime because I want the mainform to show me the totals for every record.

 

[Pat Hartman]

Add a footer to the subform. You'll need to resize the form to make it show. In the footer, add a control that sums the field you want the total of:

=Sum(YourField)