Multiple Selections in Combo Box

  • Thread starter Thread starter M Taimanov
  • Start date Start date
M

M Taimanov

I have a report - for this example, we'll say its about
cars.

I have a Car Category form which has a combo box listing,
car makers.

Select a car maker from the combo and it runs a macro which
runs this :

=IIf([Forms]![Category Report Filter]![Select Category] Is
Null,"","[Category] = Forms![Category Report Filter]!
[Select Category]")

This is fine.

What I would like to know is how to select more than one
entry or car maker from the combo box - so that I could
list say, all Audi and Ford models etc. Rather like using
the ctrl & click or shift & click techniques you find on
web site lists.

Thanks for any help or guidance.


Mark
 
Just to tag along on Wayne's post, be aware that multiselecting in a list
box changes how you refer to what was selected. You can no longer simply
refer to the control, and expect to see all of your selections.

See http://www.mvps.org/access/forms/frm0007.htm at "The Access Web" for one
approach to using multiselect list boxes as the input for queries.

--
Doug Steele, Microsoft Access MVP



Wayne Morgan said:
1) You can't do it in a combo box.

2) You can do it in a list box. Set the list box to Simple multi-select and
you can simply click on items to select them and click again to deselect
them. Set the list box to Extended multi-select and then you get what you
mentioned that you are trying to avoid, ctrl+click and shift+click.

--
Wayne Morgan
Microsoft Access MVP


M Taimanov said:
I have a report - for this example, we'll say its about
cars.

I have a Car Category form which has a combo box listing,
car makers.

Select a car maker from the combo and it runs a macro which
runs this :

=IIf([Forms]![Category Report Filter]![Select Category] Is
Null,"","[Category] = Forms![Category Report Filter]!
[Select Category]")

This is fine.

What I would like to know is how to select more than one
entry or car maker from the combo box - so that I could
list say, all Audi and Ford models etc. Rather like using
the ctrl & click or shift & click techniques you find on
web site lists.

Thanks for any help or guidance.


Mark
Click to expand...
Click to expand...
 
Back
Top