Stephanie T.
Registered User.
- Local time
- Today, 01:15
- Joined
- Jun 20, 2002
- Messages
- 60
Cascading Combo Boxes, yes another question on these.
I know that there is a lot of information regarding Cascading Combo boxes, but I cannot seem to find exactly what I need, so I hope someone out there will help me out, as so many of you on this forum already have.
First, you must know that I am working with Access 97, so I cannot open the sample databases written in Access 2000 (unless you can “save as” an earlier version).
Here’s the scenario:
My form is called frmSalesOrders (this is where our sales orders are entered). On this form is a field for entering our “bill to/distributor” customers (a combo box bound to the table tblDistributors). I also have a “ship to/warehouse” box because many of our distributors (customers) have multiple “ship to/warehouse” addresses (the information for these addresses are in a table called tblWarehouses, the information for these are entered through a subform on the Distributors form).
What I would like to do is set it up so that when a “bill to/distributor” customers is chosen from the “bill to/distributor” combo box, the only choices in the “ship to/warehouse” field will be those for that customer. If the customer only has one "ship to/warehouse" address that would AutoFill, if they have more than one "bill to/distributor" address, my data entry person can choose the correct warehouse (via a combo box), but her choices will be limited to only those warehouses connected with that customer.
I know this is a simple cascading combo box, but I cannot find how to write the code properly. I have reviewed this site, but cannot seem to find what I need, I have also reviewed my Access VBA Handbook and can find nothing useful.
Sorry for bringing this up again, any help will be greatly appreciated!
Thank you,
Stephanie
I know that there is a lot of information regarding Cascading Combo boxes, but I cannot seem to find exactly what I need, so I hope someone out there will help me out, as so many of you on this forum already have.
First, you must know that I am working with Access 97, so I cannot open the sample databases written in Access 2000 (unless you can “save as” an earlier version).
Here’s the scenario:
My form is called frmSalesOrders (this is where our sales orders are entered). On this form is a field for entering our “bill to/distributor” customers (a combo box bound to the table tblDistributors). I also have a “ship to/warehouse” box because many of our distributors (customers) have multiple “ship to/warehouse” addresses (the information for these addresses are in a table called tblWarehouses, the information for these are entered through a subform on the Distributors form).
What I would like to do is set it up so that when a “bill to/distributor” customers is chosen from the “bill to/distributor” combo box, the only choices in the “ship to/warehouse” field will be those for that customer. If the customer only has one "ship to/warehouse" address that would AutoFill, if they have more than one "bill to/distributor" address, my data entry person can choose the correct warehouse (via a combo box), but her choices will be limited to only those warehouses connected with that customer.
I know this is a simple cascading combo box, but I cannot find how to write the code properly. I have reviewed this site, but cannot seem to find what I need, I have also reviewed my Access VBA Handbook and can find nothing useful.
Sorry for bringing this up again, any help will be greatly appreciated!
Thank you,
Stephanie
