Running a query OnChange

[zb134]

Hi I pretty new to access...I am creating a form where it would show up the employees assigned to a particular supervisor.
The supervisor is selected using a drop down list. I want to use the selected supervisor to run a query to find the corresponding employees.
However, I can't figure how to actually run the query. I tried entering this

SELECT EmployeesList.[First Name], EmployeesList.[Last Name], EmployeesList.Supervisor FROM EmployeesList WHERE (((EmployeesList.Supervisor)=[Forms]![AssignmentsBysup]![SupervisoSelection]]));

in the On Change filed but that gives an error.

Please help

[June7]

Where is that SQL used? That it is red suggests you tried it in a VBA procedure.

A SELECT sql is used in VBA to open a recordset. Just the statement standing alone can do nothing but error.

Review this tutorial for one method to filter form http://datapigtechnologies.com/flash...tomfilter.html

And from the same site http://datapigtechnologies.com/AccessMain.htm review the 3 on comboboxes in the Access Forms: Control Basics section.

[RayMilhon]

Without knowing more about your project here's a step in the right direction. On your form you have 2 controls 1 is a combo box with the source as your list of Supervisors. the second is a list box with your SQL Statement as your RowSource in the onchange event of the combobox have the listbox refresh. You'll have to work out the details yourself.