I am trying to add a filter to a form, that will only allow user to see data from their own department. Tried advanced filter sort, but cannot seem to use the right code to have people look at their own department personnel. I have a signin table and form, as was using that to pull the user department. Have tried many options none are working correctly. As soon as the filter is in use, I can see no records at all. If I remove then everyone has Access to all information. Please help I am trying to roll this database out asap.
