Multiple criteria from a combo

[Johnny]

Hi,

I have a combo box (query based) on a form that, when
selected, populates a text box. The text box will be the
holder for criteria for a report.

The question is, how can I use the combo box to select
more than one item as criteria for the report?

What I need is some way to pick from the combo to populate
a list of criteria.. Can anyone help?

TIA
Johnny

 

[Roger Carlson]

If you are going to do multiple selections, the multi-select listbox is a
better option. It's just a regular listbox with the MultiSelect property
set to Simple or Extended. Then you have to use code to build the query.

On my website, see sig below, is a small sample database called
"CreateQueries2" which illustrates how to do this. See Form 6.

 

[Johnny]

Many thanks. I'll give that a go.

J

-----Original Message-----
If you are going to do multiple selections, the multi- select listbox is a
better option. It's just a regular listbox with the MultiSelect property
set to Simple or Extended. Then you have to use code to build the query.

On my website, see sig below, is a small sample database called
"CreateQueries2" which illustrates how to do this. See Form 6.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.