<div>
You can refer to a textbox in your subform containing the total in VBA like this:<br />
<br />
Me.SubformName.Form!txtTot<wbr />al<br />
<br />
You can also use that same reference in a control source property, but omit the &quot;Me.&quot; if you are using this in a property sheet or query (&quot;Me.&quot; is a VBA prefix)
</div>


You can refer to a textbox in your subform containing the total in VBA like this:

Me.SubformName.Form!txtTotal

You can also use that same reference in a control source property, but omit the "Me." if you are using this in a property sheet or query ("Me." is a VBA prefix)

<div>
Hi<br />
<br />
Can this SubformName.Form!txtTotal be used in the main forms query?<br />
<br />
Does it have to be a text control?
</div>


Hi

Can this SubformName.Form!txtTotal be used in the main forms query?

Does it have to be a text control?

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
I have a subform that calculates a total from data in the subform. The main form also has calculated totals. I want the total from the subform to be part of the grand total on the main form.<br />
<br />
I have been told that this should not be done grammatically as part of an event.
</div>
</div>


Hi All

I have a subform that calculates a total from data in the subform. The main form also has calculated totals. I want the total from the subform to be part of the grand total on the main form.

I have been told that this should not be done grammatically as part of an event.

Subform total in Main form

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.