Originally Posted by
SierraJuliet
After changing
CurrentDbOpenRecordset strSQL to
DoCmd.RunSQL strSQL it did not work so I changed it back and now I get another error with the following.
Code:
aCase = "SELECT CaseNum FROM tblCase WHERE ClientNum Like '" & tClient & "' "
Code:
DoCmd.SetFilter , "[CaseNum] Like '" & aCase & "' AND [AssignedDepartmentGroup] Like '" & DepartmentGroup & "' AND [AssignedManagerGroup] Like '" & ManagerGroup & "' OR [AssignedStaff] Like '" & Staff & "'"
Attachment 37225
The issue was DoCmd.SetFilter because it uses WHERE Clause and the first part contained SELECT * FROM * Clauses.
Code:
DoCmd.SetFilter , "[CaseNum] Like '" & aCase & "' OR [AssignedDepartmentGroup] Like '" & DepartmentGroup & "' AND [AssignedManagerGroup] Like '" & ManagerGroup & "' OR [AssignedStaff] Like '" & Staff & "'"