Total Amount

[Vina]

I have a form that has a subform.
Header Information and a Subform for detail information.
I have all the list of items and extended price in the
subform, how can I total the lines in the subform and
show the total order amount in the header section which
is the main form.

Any ideas??

 

[Cameo]

In the header or footer of the subform, add a control to sum the prices
(e.g., Sum([ExtPrice]). Be sure to name the control, i.e., SumExtPrice

In the Main form, create a control to reference the SumExtPrice control in
the subform, i.e., = [subform]![SumExtPrice] ... or something like that as
I don't remember the syntax for referencing subforms off the top of my head.

Cameo