combo box

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

Guest

I have field called Suffix which has a list of values in a combo box. I have
a parameter in a query that lets the user select the suffix prior to running
the query. Is there a way to allow multiple selections of a suffix instead
of enter one? Is there a way to do this as part of query design or a form
design?

Thanks
 
You will need to change the Combo box to a List box. Combo boxes do not
allow multi select, but List boxes do.
Then for your query you can use the IN predicate. It would end up looking
something like:
IN("Jr", "Sr", "Esq", "MVP")

To build this string, you will need to write a funtion that spins though the
ItemsSelected collection of the List box and put the string together. There
are now a couple of options. One would be to create an invisible text box on
your form you put the string in. You would reference that text box in your
query. The other is to modify the SQL string of the query directly.
 
Back
Top