Summing from a child form's fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?


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
 
Back
Top