List box with multiple values as query base

[ppataki]

Dear All,

I would like to create a list or an option group on a form, where users can select not only one option but multiple values at a time
After selecting a query would run using the selected values as criteria

How can I create a multiple selection option in Access 2000?

Many thanks in advance

 

[DCrake]

Yes you can do this, what is your problem?

 

[ppataki]

The problem is that I dont know how to do it
What control shall I use and how?

Thank you!

 

[DCrake]

Do you not think that you answered the question yourself in the title of this post?

Use a Listbox and set the multi select option to Simple. That way the user can select more than one item in the list box. Avoid using tick boxes or option groups wher possible.

David

 

[ppataki]

Now it works!!!
I did not know which option enables multiple selection, but now I found it that you mentioned its name

Many thanks for your help