Limiting Product List By Customer

[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.

 

[John Vinson]

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.

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.