Hi Everybody,
I am trying to create a text box on the form that would show subtotal of the specific column on the subform above it. The subform is based on the query that runs each time a combo box is changed and it refreshes the subform. I have tried sourcing the text box as Sum([Query name],Column Name]), but that is returning #Error in the box.
Is it possible to make this work?
Thanx in advance
Chris

Hi Twin

Have you tried referencing the fields on your subform? Let me assume certain things.

You have a subform (frmInvoiceSub] with a text box called [txtCost](based on the query field [Cost], but named with prefix txt) on a main form called frmInvoice. Note that the field name and text box name are different (which Access does not automatically do - leave them the same and an error can occur as two objects have the same name).

On the main form you create an unbound text field called [txtTotal]. The control source for this references the subform (as an integral part of the main form). Therefore you will put the following as the control source:

=Sum(Me!frmInvoiceSub!txtCost)

or

=Sum(Me!frmInvoiceSub!Cost)

or

=Sum(frmInvoice!frmInvoiceSub!txtCost)

"Me" is used as a short name for the form (or report) currently open.

HTH

Rich