Totals in a Form

Invoice Example

Suppose you have a form which you want to have total up the amount on the bottom. To do this, create an unbound text box in the form's "footer" section. Assuming you are totaling a field named [invoice_amount], the syntax of the unbound text box would be:

Again, this would appear in the FOOTER of your form.

Referencing A Subform's Total Text Box in the Parent Form

Assuming you have a parent form and you want to reference a total text box located in the parent form's subform. Assuming the subform has a control name of sfrInvoices in your parent form and the name of the text box in the subform is called txtSum, the syntax to reference this control would be: