L
Lauren B
I'm attempting to set up two combo boxes on a subform (Subform1) that exists
within a larger form (Form1). The first box (VENDORS) lists "vendors" and
the second box (PRODUCTS) lists "products" for each individual vendor.
I have a table (VendorTable) that contains a list of all vendor and
products, which I want to draw off of to create the corresponding drop down
boxes.
I am working to control the second drop down box through a query based on
the value in the first drop down box. Typically, I would put the following
in a query as the row source for the product field:
[Forms]![Subform1]![Vendor]
However, this does not work when the subform is included within the larger
form.
How do I need to write the row source query for the second drop down box so
that it adequately reflects information based on the value chosen in the
first drop down box?
within a larger form (Form1). The first box (VENDORS) lists "vendors" and
the second box (PRODUCTS) lists "products" for each individual vendor.
I have a table (VendorTable) that contains a list of all vendor and
products, which I want to draw off of to create the corresponding drop down
boxes.
I am working to control the second drop down box through a query based on
the value in the first drop down box. Typically, I would put the following
in a query as the row source for the product field:
[Forms]![Subform1]![Vendor]
However, this does not work when the subform is included within the larger
form.
How do I need to write the row source query for the second drop down box so
that it adequately reflects information based on the value chosen in the
first drop down box?