Combo box based on another combo box

G

Guest

Hello all,

I've read the Microsoft Office Online help at
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx, but I can't
figure it out. I'm a "Newbie" at this.

I have a Lease Management database with over 100 stores. Those stores are
broken down into Regions and then districts.

The main tables for this combo box are:
tblstores (storeID, address, etc.)
tblregions (regionID, storeID, Region, Region VP) There are 3 regions.
tbldistricts (DistrictID, regionid, District, District Manager) There are 9
districts.

How do I create a combo box for the Region which will then populate the
Region VP text box, as well as populate the District combo box with only
those districts and district managers from that region?

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box based on another combo box 3
Update control from another control 2
Populate field based on combo box 2
Filtering combo boxes based on a selection in another combo box 1
In a form, how can I populate a Combo Box from a selection from a. 1
Combo box doesn't always show data 4
auto populate text box based on combo box value 1
Combo box based on another combo box 1

Top