Relational Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
ACase said:
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.
Click to expand...

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