<div>
I just discovered that the value on the subform IS NOT changing. &nbsp;Why would that be?
</div>


I just discovered that the value on the subform IS NOT changing.  Why would that be?

<div>
Never mind. &nbsp;I got that.
</div>


<div>
<div class="content wysiwyg-content">
I have a form which contains a subform. &nbsp;When records are added to the subform there is a total in the footer of that subform. &nbsp;The value of this total is supposed to update in a separate field on the &nbsp;main form when records are added to the subform but it isn't changing.<br />
<br />
The Main form is named frmInvoiceMaster and the field on that form which is supposed to update is named txtInvoiceTotal<br />
<br />
The subform is named frmInvoiceDetail and field in the form's footer which DOES recalculate when records are added is named txtTotal.<br />
<br />
How can I make the field in the main form recalculate when records are added to the subform?<br />
<br />
--Steve
</div>
</div>


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

Main Form field not changing when subform field total changes

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.