2 combo box query

T

tbarse98

I'm sure this is simple, but im relatively new to access. this is what I
need to do:
I have multiple customers who use different shippers I need to pull up first
a customer by combo box, and then a second combo box to select shipper and
then query the results. I have it working fine for the customer only but
don't know how to add the additional combo box
EX:
Customer Shipper
One First
Second

Two First
Third

Three Second
Third
Fourth

I want to enter first Customer One and then choose from combobox2 either
First or Second Customer

It would be nice if the 2nd combo box would only give me choices that are
available and not the entire list of shippers.

Thanx in advance
 
M

Marshall Barton

tbarse98 said:
I'm sure this is simple, but im relatively new to access. this is what I
need to do:
I have multiple customers who use different shippers I need to pull up first
a customer by combo box, and then a second combo box to select shipper and
then query the results. I have it working fine for the customer only but
don't know how to add the additional combo box
EX:
Customer Shipper
One First
Second

Two First
Third

Three Second
Third
Fourth

I want to enter first Customer One and then choose from combobox2 either
First or Second Customer
Click to expand...


See if this helps:
http://www.mvps.org/access/forms/frm0028.htm
 
Top