Relational Combo Boxes

[Guest]

Hello;

I am builiding a Report Form, which allows the user to select a report, then
choose how they want it filtered.

The filters are a set of combo boxes - their values are added to the
strWhere clause through code.

My question - The data contained in these combo boxes are derived from
tables that are relational. I want their contents to dynamically change
based upon the users selection. Example: I have 3 combo box filters.
Division - Region - Sector.
One Division has multiple regions, and one region has sectors. I want the
contents of the combo box 'Region' to change based upon the user's Division
selection.

Any help would be much appreciated.

Thanks
Acase

 

[Rick B]

Asked and answered all the time. Do a search and read the previous posts.
Look for the term "cascading combo" and you should find them. I believe
there are even knowledge base articles on the MS website that explain this
process.

 

[Marshall Barton]

I am builiding a Report Form, which allows the user to select a report, then
choose how they want it filtered.

The filters are a set of combo boxes - their values are added to the
strWhere clause through code.

My question - The data contained in these combo boxes are derived from
tables that are relational. I want their contents to dynamically change
based upon the users selection. Example: I have 3 combo box filters.
Division - Region - Sector.
One Division has multiple regions, and one region has sectors. I want the
contents of the combo box 'Region' to change based upon the user's Division
selection.

See:
http://www.mvps.org/access/forms/frm0028.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;209595