Control Value Calculation

I have tried numerous methods to obtain a sum value displayed within a control box on a form. The calculation occurres within one colum of a subform. and concerns a customers purchase of several items.

This is very similiar to the example given in the Northwind database concerning the orders form where it calculates a subtotal then adds freight for a total. Because my form does not incorporate a frieght charge I have tried to use the subtotal calculation without success.

I would really appreciate some insite on how to accomplish this. Or a better method. I have also tried this on the footer of the subform without luck. I really need the formula that will work

thanks Coop

In the subform:
add an Unbound text box and call it MySumFieldInSubForm
and set
ControlSource= Sum(FieldToSum)

In the main form:
add an Unbound text box:
set controlsource to

ControlSource = [subformCONTROLName]![MySumFieldInSubForm] + AllTheRest

ok now for another question on the same subject.

how do you divide 2 fields when they are using the calculation

=Sum([example1]) and =Sum([example2]) to get a percentage.

thanks

Without testing that [MyTextField1]/[MyTextField2] works I would say put a field with [example1] / [example2] in the details section and the sum of it in the group or report or page header/footer

thanks got it to work.