Running a query on items selected from a list box.

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

Guest

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

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


Thomas said:
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?
Click to expand...
Click to expand...
 
Back
Top