Hi,
I have a Form that has two combo boxes:
1. Customer dropdown box
followed by:
2. Locations dropdown box
First, I want the user to select from the dropdown box the customer name, then after they have chosen the customer name, I want the second dropdown box to already find the list of the store locations of that particular customer. So everytime a new location is chosen from the first dropdown, the list of the second dropdown will change accordingly.
I did this by editing the row source of the second dropdown to something like this:
select distinct locations
from <customer table>
where <customer table>.customer = [Forms]![Update]!customer;
The first time I open the form and selected the customer, the right locations are listed in the combo box. However, after this, when I choose another customer, the customer location list is unchanged!
Thanks so much in advance.
I have a Form that has two combo boxes:
1. Customer dropdown box
followed by:
2. Locations dropdown box
First, I want the user to select from the dropdown box the customer name, then after they have chosen the customer name, I want the second dropdown box to already find the list of the store locations of that particular customer. So everytime a new location is chosen from the first dropdown, the list of the second dropdown will change accordingly.
I did this by editing the row source of the second dropdown to something like this:
select distinct locations
from <customer table>
where <customer table>.customer = [Forms]![Update]!customer;
The first time I open the form and selected the customer, the right locations are listed in the combo box. However, after this, when I choose another customer, the customer location list is unchanged!
Thanks so much in advance.
