Using a Check Box In Coordination with a Combo Box

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

Guest

I am trying to figure out how to incorporate both the functionalities of a
check box and combo/list box feature. It gives the user either the ability
to select all data through the use of a check box and/or select a specific
value through the combo box.

How do I get both of these options to work? (I need this to feed into the
criteria
line of my query. )
 
Terri,

It sounds like you need a multi-select listbox! Have you considered this
option? It is a listbox with its Multi-Select property set (usually) to
Simple (default is None), so it allows the user to select any number of
consecutive or non-consecutive rows. The only downside (for some) is
that it can only be "read" through VBA code, but it is a great
enhancement to User Interface functionality. If you decide to go that
way, you might want to add a couple of buttons or checkboxes for Seelect
All and Deselect All (through simple code).

HTH,
Nikos
 
Back
Top