I'm usingto filter my employees/staff.Code:
Me.Filter = "([Employees_employeeid] Like ""*" & Me.EmpSelect & "*"")"
It works but because of the wildcard elements its throwing up multiples now i.e. employee 8 and 18 together if 8 is the employees ID.
However, when I remove the wildcards the filter fails every time.
What am I missing?