DoCmd.SetFilter

[SierraJuliet]

I am trying to make a form only allow user to view data if they meet all the criteria with exception to the first part (StaffNum)

CurrentDb.OpenRecordset strSQL

DoCmd.SetFilter , "[AssignedStaff] Like '" & Staff & "' OR [AssignedDepartmentGroup] Like '" & DepartmentGroup & "' AND [AssignedManagerGroup] Like '" & ManagerGroup & "' AND [AssignedCaseGroup] Like '" & CaseGroup & "'"

Me!
[listSearch].RowSource = strSQL

Me!
[listSearch].Requery

1. Staff Number

Each staff member may have something specifically directed to them.

2. The user works in the specific categories: Department Group > Manager Group > Case Group

Each staff member will fall under a category: For each department group there are manager groups and for each manager group there are case groups.

[SierraJuliet]

Disregard the code works as is. Just need to logout and log back in for changes to take effect.