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

1. The combo boxes should be bound.
2. The query for combo2 should reference combo1 and the AfterUpdate event of combo1 should requery combo2.
3. The query for combo3 should reference combo2 (and combo1 if necessary) and the AfterUpdate event of combo2 should requery combo3.