Link to home
Start Free TrialLog in
Avatar of J G
J G

asked on

Cascading Combo boxes between 2 sub navigation forms

I have a main form with a navigation form that has 2 sub-forms.

I want the combo box choices in one sub form to be based upon what is populated in the other sub form.

What is the best way to accomplish this?

PLU is the common key field
1 sub-form (vendor_item) is for entering vendors, order numbers, and costs - with a corresponding table called vendor_item
1 sub-form (store_item) is for entering retail prices based upon the vendors, order numbers, and costs entered in the first sub-form.  This sub-form will have a corresponding table called store_item.  In this sub-form there will be multiple cascading combo boxes based upon values in the first sub-form/table that will in turn update this form's corresponding table.

I have been able to get the store_item combo box to populate correctly using the row source query below, however When I try to make a selection it will not populate the form field or write to the store_item table.

SELECT tbl_Vendor_Item.VendorName
FROM tbl_Vendor_Item
WHERE (((tbl_Vendor_Item.PLU)=[tbl_Store_Item].[PLU]));
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial