Calculate Totals from Tab Subform

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

Guest

I am getting an error prompt. Order_Details subform is calculating a
subtotal field, which is then summed in the hidden footer as Order_Total.

The Main orders page contains three tabs, of which one is the order details.
How do I properly refer the Total text box from Main_Order to Order_Total in
Order_Details subform located in my tab?

Am I having problems because the subform is on the tab?
Thanks,
Ivan.
 
Ivan,

No, the fact that the subform is on a Tab Control is not relevant.

The following expression in the Control Source of an unbound textbox on
the main form...
=[Order_Details]![Order_Total]
.... should do it. Some prefer the fuller syntax of...
=[Order_Details].[Form]![Order_Total]

This assumes that Order_Details is the name of the subform control,
which isn't necessarily the name of the form which is used as the
subform. It also assumes that the Order_Total control on the subform is
correctly showing a valid value.
 
Back
Top