Loop and display names from a query

[oxicottin]

Does the query you are using have any Parameters or Criteria set, if so Access VBA does not like them.
You may be able to get the criteria to work by setting them as Parameters.
The alternative is to build the SQL statement for the query in the VBA code.

Threre isnt really prameters in query other then the text box on my form

SELECT [EmpFName] & " " & [EmpLName] AS EmployeesName, tblEmployees.EmpFName, tblEmployees.EmpLName, tblEmployees.SupID, tblEmployees.SupID
 FROM tblEmployees
 WHERE (((tblEmployees.SupID)=[Forms].[frmEditSupervisors].[txtSupID]));

I tried the VBA and same error..

strSQL = "SELECT [EmpFName] & ' ' & [EmpLName] AS EmployeesName, EmpFName, EmpLName, SupID " & _        "FROM tblEmployees " & _
        " WHERE SupID= " & Me.[txtSupID]