I have a form which contains a subform. When records are added to the subform there is a total in the footer of that subform. The value of this total is supposed to update in a separate field on the main form when records are added to the subform but it isn't changing.
The Main form is named frmInvoiceMaster and the field on that form which is supposed to update is named txtInvoiceTotal
The subform is named frmInvoiceDetail and field in the form's footer which DOES recalculate when records are added is named txtTotal.
How can I make the field in the main form recalculate when records are added to the subform?