update form with calculated total of rows in subform

[joebloeonthego]

Let me clarify....

I have a form where users enter information about a product return. There is a subform because there can be more than one partnumber per return. They have been manually calculating the cost and entering it on the form. They want this done automatically.

I will have to run through the subform, totaling each row, then put the total in the textbox on the form.

the subform is in the format of:

pn qty

and i have the cost available to me in the pn table.


I don't know how to 'loop' through the subform for starters, from there I can probably get most of it figured out.

thanx!

 

[Remou]

You can add a textbox to the footer of the subform and refer to that. Have a look at the Orders form of the Northwind sample mdb.

 

[joebloeonthego]

thanx, I should be able to figure it out from there...

 

[TheAceMan1]

joebloeonthego . . .

In parallel with [blue]Remou[/blue], Sum the subform field by using a calculated control in the subform's form footer.

Reference the calculated control from the main form to display the summed value.

ControlSource: =subFormName.Form!SumControlName

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886