I have a series of 3 unbound combo boxes on an order form. The second requeries the first to update only pertinent info based on the first selection with an AfterUpdate event. The third does the same to the second. This all works great...my problem is figuring out how to copy this info into fields on the OrdersSubform bound to the Orders table after the selections are made. If the combo boxes are bound to the Subform, the Requery event erases prior entries made on the Subform.
I know I a missing something obvious and hope that a more experienced Access designer can give me a hand. Thank You...Rob
I know I a missing something obvious and hope that a more experienced Access designer can give me a hand. Thank You...Rob
