dropdown to set multiple query filter criteria

[soulpiercing]

I am currently working on a criminal justice tracking program for the US Army. The structure of our legal office is set up in a way that we can all use a centralized database which will make reports and tracking at all levels easier but there is an issue I am trying to resolve.

Our office structure looks something like this:

MAIN legal office

1st Sub office

2nd sub office

3rd sub office


What I want to do, is on my main screen have a drop-down list of these offices (based on a table "offices"). Depending on the selection from this list, I want a filter to be applied to ALL queries so that if I work in the 2nd sub office - the cases from my office are all I see.

In every case, there is a selection of "unit" and in the unitdata table, the sub office is selected from "offices"

The main office would be set to view ALL data with no filters.

Issues:
this program will likely be used in other stations as well so the names of the sub offices will change as will the number of sub offices.

Ensure Key numbers are assigned regardless of which filter is in place. (shouldn't really be an issue).

Thanks for any help.

 

[ghudson]

croby,

Check out my posted filteredcomboboxes.zip sample. It should show you how to do what you want with multiple combo boxes.

HTH