how do I set a list box as parameter to a query criteria?

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

Guest

Is it possible to build a query in which the criteria is a list box? I have
a list of workers and I want to build a query that will prompt me with the
list.
Thanks ... Marco
 
You can use a list box like a text box in the criteria of a query:
Forms!frmYourForm!lboYouListBox
This won't work for multi-select list boxes.
 
Duane/Marco

I'm sorry to jump in on this thread (and hopefully you both are still
monitoring it...) but I have a similar problem, only I need to use a multi
select list box.

Any ideas how I should proceed with being able to select more than one item
from a list box and use that for the query? I have tried it a bit in code,
but think that I was not approaching it from the correct direction.

any pointers here would be appreciated.

Jasonm
 
Back
Top