Multiple or Combination of Choices

  • Thread starter Thread starter jsccorps
  • Start date Start date
J

jsccorps

Have 3 vendors. Plan is to use check boxes to indicate which vendor or
vendors to pull data for. Want to be able to pull data for any combination
of vendors (e.g., a single vendor or multiple vendors). Does not seem that
Option Group will work. Any other ideas?
 
jsccorps said:
Have 3 vendors. Plan is to use check boxes to indicate which vendor or
vendors to pull data for. Want to be able to pull data for any
combination
of vendors (e.g., a single vendor or multiple vendors). Does not seem
that
Option Group will work. Any other ideas?
Click to expand...


For this sort of thing, I usually use a multiselect list box, build the
query criteria on the fly based on the selected items in the list box.
 
In a somewhat similar situation, I simply added a true/false field to
my vendor table.

Then on the form where the report was to be selected from I created a
subform with query that showed the vendor names and the check box.

1 button to reset all checks to false
1 button to set all checks to true
instructions to select those vendors that were to be included in the
requested report.

Then the report query had the vendor table with true in that field as
the control of whether to include in report or not.

Caveat:
More than one user could obviously not run the report at the same
time.
To get around that in one app I created a local table with only those
two fields and had that table emptied and reloaded when entering the
form.

If you have "Closed" vendors be sure to add that criteria to the
selection process somewhere.
Ron
 
The another advantage to that type of logic is that no changes are
necessary if (when) vendors are added and/or you can add a field to
the vendor table to say whether this vendor should be included in this
type of report or not even if the vendor is still active.
Ron
 
Back
Top