Originally Posted by
OBP
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]