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.