Software

Ask something
Question Locked

Filter form

0 helpful
2 replies

by wyscavern

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by tink!

after you apply the filter than it is not finding records to match the data you are searching for.

Do you have a field that names the departments? Is that the field you are using to filter the records?

Are you trying to add this filter using the button wizard or via manually entering the VB code?

Is the filter to be run before or after they have opened the form?

Usually using a query to filter the form upon opening is easiest. Just create the query first, sorting or filtering by the field you wish. Then Open the form with the query name in the "LinkCriteria" part of the Open Form command.

Just let me know if you need more detailed help.

This discussion is closed to new replies.