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
 
Is the query used as the record source for a form or report?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

passing a parameter based on multiple selections 7
Use In() Expression as Query criteria with guts from Function 1
Parameter Query Lookup 2
How do I make query parameters with a drop down list? 1
Parameter Value in Crosstab Query 4
select a criteria's parameter from a combo box on a form 2
Access Dcount (multiple criteria) 3
Multiple Parameter Crosstab query filter by form 1

Back
Top