I have created a purchase order (PO) form with a subform that will collect and calculate a cost savings between the "Original Price" and a "Negotiated Price" for the items on the PO. The last input is the negotiated price, which triggers an "On Exit" event, where VB code correctly calculates the extended price (to an unbound control) and the column totals and cost savings to other unbound contols on the subform's footer.
Private Sub numPrice_Neg_Exit(Cancel As Integer)
numPrice_NegExtend = numPrice_Neg * numQuantityDT
numPriceNegTotal = numPriceNegTotal + numPrice_NegExtend
Then the program cannot goto or add the next record on the subform. My settings on the Mainform is set at Single Record with the Subform set at Continuous Records. The tables: Main Table to Sub-table are set at One to Many relationship. The tables are linked tables. Any suggestions?