Subform Total in Main Form
Posted on 2013-09-21
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 programmatically as part of an event.
I had this from the original question: You can refer to a textbox in your subform containing the total in VBA like this:
This gets the total onto my main form but I need it in a bound control to keep a permanent record or I need it to be part of the main forms underlying query so that it can automatically form part of a query for later use, in a report for example.
I hope that that’s clear