Hello,
I am a newbie to Access and need help with filtered combo boxes from the gurus out there.
I am trying to filter a combo box in a subform based on the value in a combo box in the main form that this subform is linked to. I then need another combox box in the subform filtered on the selection made in the previous combo box. The first combo box in the main form is a list of Customers. After a customer in the main form (titled frmPurchaseOrder in the attached database) is selected then I want the first combo box in the subform (titled subfrmPurchaseOrderDetail) to display a list of the Orders for that customer. Once the Order is selected in this combo box then I want the next combo box (also in the subform) to display a filtered list of items for that Order.
The Orders combo and OrderDetails combos are both based on queries (named “qryOrderSearchForPO” and “qryOrderDetailIDSearchForPO” in the attached database).
Any help you can provide to fix this would be much appreciated as I cannot get this to work.
Thank you!
Dip8324