Limiting Product List By Customer

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I have a Customer DB with a customer table and product
table. Each product is entered by customerID in the
table. My issue is in the Order Form I want to be able to
select the Customer from a drop down field and then have
ONLY those products listed in the Product drop down
field. When I select the customer in the drop down field
all records are displayed in the products drop down.

Appreciated any help.
 
I have a Customer DB with a customer table and product
table. Each product is entered by customerID in the
table. My issue is in the Order Form I want to be able to
select the Customer from a drop down field and then have
ONLY those products listed in the Product drop down
field. When I select the customer in the drop down field
all records are displayed in the products drop down.

Appreciated any help.
Click to expand...

There are a couple of ways to do this: see

http://www.mvps.org/access/forms/frm0028.htm

for an example. A third way is to dynamically construct a SQL string
for the Order form Product combo box in the AfterUpdate event of the
Customer combo box, setting it to a query referencing the selected
customer.
 
Back
Top