General filter question.

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

Have a database for voting. There are districts, then towns, then parties
(dem / repub). I need to filter down to parties by possibly one district -
possibly a group of districts.

Should I start with a form and parameters? Then from that a report? Using a
list?

Before going too far, I want to make it very efficient because of the size
of the DB.

thanks.
rob
 
I would start with a form. On that form I would have List Box controls for
each of the entities (District, Town). For Party, I would suggest an option
group with a selection for each party. Make your list box controls Multi
Select property Extended so you can select multiple entities from the lists.

This is going to take some VBA coding. Once you have selected the Districts
you want, you will have to recreate the Record Source for the Town list and
requery it so you get a list of towns in the selected districts. Once you
have selected from both lists and selected a party, then you will need to
build a Where Condition for your report so it will include only the selected
data.
 
Back
Top