List box not working correctly

  • 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!
 
Hi,
We'd have to see how you're building your SQL string.
Also, just in case you're not aware of this, you can't simply
put a reference to a multi-select listbox directly in the query grid like:
Forms!yourForm!yourListbox
 
Back
Top