Combo box based on another combo box

[D. M.]

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.

 

[Wayne-I-M]

This is a better site to look at

http://www.mvps.org/access/forms/frm0028.htm