Filtering Choices In Combo Box

C

chip

OK, not an Access Expert, so my solution should be fairly simple...hopefully
someone can help.

I need to filter a drop down box so it doesnt list all the choices based on
a previous "filter" variable.

Here's what I mean:

I need a "Base Name" combo box to list only base names associated with a
combo box selection (MAJCOM Name) which is on a form I want the data to
display on.

Looks something like this:

MAJCOM Name ("Filtering" Combo box) | BASE Name ("Fltered" Combo Box)
ACC Langley AFB
Luke AFB
Seymour J. AFB
Etc.

AMC Scott AFB
Travis AFB
McGuire AFB
Etc.

The bases are associated with a MAJCOM in a single table.

The MAJCOMs are also listed in another table (the database is suffering from
some "mission creep" as the customer came back later and wanted further
functionality so when I got the spreadsheet with the base names, I had to
import them to a new table and hence the two tables with MAJCOMs) which
filters a form so I need the bases to filter using that same combo.

I am very sorry this is so verbose, but I knew of no other way to try and
describe my dilemma...

Any ideas?

Thanks in advance,

Chip
 
Top