Summing from a child form's fields

J

John

I have a PO form ("frmPOs") that contains a subform ("frmPOLines") (continous
forms) for inputting line items for the PO. These line items each have a
cost field ("AmtNotExceed"). I want to create a field in the PO (parent)
form that will sum all the amounts listed in the "frmPOLines" (subform)
"AmtNotExceed" field. Is there any way to do this?

Thanks in advance.
John
 
M

Marshall Barton

John said:
I have a PO form ("frmPOs") that contains a subform ("frmPOLines") (continous
forms) for inputting line items for the PO. These line items each have a
cost field ("AmtNotExceed"). I want to create a field in the PO (parent)
form that will sum all the amounts listed in the "frmPOLines" (subform)
"AmtNotExceed" field. Is there any way to do this?
Click to expand...


The subform must do its own calculations. Typically, this
is done by using a text box in the subform's footer section.
The text box expression would be something like:
=Sum(AmtNotExceed)

If you really need to display that total in the main form,
then add a text box to the main form that uses an expression
like:
=subformcontrol.Form.textboxonsubform
 
Top