List Box not working

  • Thread starter Thread starter Robert Ross
  • Start date Start date
R

Robert Ross

I have a database where a supervisor logs in and can run
reports on their employee's stats. When the supervisor
logs in, they are shown a list of employees for their
team. These results are shown in a list box. I want the
supervisor to be able to choose 1 or more employees to run
a query on.

I have the list box built to show the 'filtered' employees
(only ones assigned to them), but when you select one or
more employees then open the query, you don't get any
results. To test the list box, I have a query that's only
supposed to show the UserID's for records that match the
UserID in the list box.

Any ideas on what I may be doing wrong?

THX!
 
How are you attempting to use the listbox in the query? If it's by putting a
reference to the listbox as a criteria for the query, that only works for
listboxes that do not have multiselect enabled.

See http://www.mvps.org/access/forms/frm0007.htm at "The Access Web" for how
to deal with multiselect listboxes and queries.
 
Back
Top