I'm trying to develop a form that will be used to enter purchase orders. The main form is attached to a purchase order table, which has a field called OrderTotal. I have a subform that updates a PO details table with the items ordered, prices, quantities.
I can calculate the order total on the subform, but how do I get it to update the OrderTotal field on the other table? Basically, how do I have a form update a field with a calculated value?