Running a query on items selected from a list box.

[Thomas]

I am trying to create a query that will only show the values for names
selected in a list.

I have a form that has a list box that shows all of the team members. In the
database there is a table that contains all of the stat information for each
team member. I have the list box's Multi Select property set to "Simple" so
that the user can select multiple agents on the list. I need the query to
only show the stats for the names selected on the list box.

Any suggestions?

 

[KARL DEWEY]

Use the listbox as criteria like this ---
[Forms]![YourFormName]![YourListBox]

 

[Thomas]

That would work if I had the Multi Select property set to None and only
wanted to select one name at a time but I need to be able to select multiple
names from the list and have the query show data for each of the names
selected.

Use the listbox as criteria like this ---
[Forms]![YourFormName]![YourListBox]
--
KARL DEWEY
Build a little - Test a little

I am trying to create a query that will only show the values for names
selected in a list.

I have a form that has a list box that shows all of the team members. In the
database there is a table that contains all of the stat information for each
team member. I have the list box's Multi Select property set to "Simple" so
that the user can select multiple agents on the list. I need the query to
only show the stats for the names selected on the list box.

Any suggestions?

 

[Ken Snell \(MVP\)]

See sample database here; it shows how you can build the WHERE clause for a
query's SQL string based on values selected in a multiselect listbox:
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterForm

 

[Duane Hookom]

There is a generic function in a sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that can
be used for any multi-select list box on any form. It's preformance may be
rather sluggish with large record sets.