Multiple criteria from a combo

  • Thread starter Thread starter Johnny
  • Start date Start date
J

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
 
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.
 
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




.
Click to expand...
 
Back
Top