Adding a total to a main form calculated from a subform

[detaylor1242]

I have two tables. Tickets and Input items. I created a sub-form and the individual ticket info is added to the database. the table calculates the UnitTotal ( Qty * UnitPrice). There are multiple items sold on the ticket.



I want to add to the ticket form and table the Sum of the UnitTotals of that ticket. ( This is a quality check on the data entry/ticket writer) After that total is entered on the ticket form it will calculate the tax and the grand total.

No idea of how to get the total from the subform over to the Ticket main form? No problem doing the calculated fields though.

Any help greatly appreciated.

[ssanfu]

the table calculates the UnitTotal ( Qty * UnitPrice).

You have a field in the table that is a calculation?? You need to read these two sites
http://allenbrowne.com/casu-14.html#CalcFieldA2010
http://allenbrowne.com/ser-45.html

Most experienced programmers avoid the use of calculated fields in tables (bad). (but calculated fields (columns) in queries are good)


(thinking out loud...)
One idea is to have the subform after update event code calculate the total and push it into the control on the main form. Or, if the there is a total on the subform, have the code take the total from the control on the subform and push it into the control on the main form.