D
dahinda1612
Hello,
I have a database that is used by the managers of several departments of a
company. The database stores information about the performance of the
employees in each department. I have a query that computes averages from
information about each employee entered by each manager. The managers enter
the data into a form with a query called qryComputeAppraisal as its record
source. To keep data integrity, I have a table called Employees with the
employee names. A combo box in the form uses this table as its record source.
The employee name when entered is then put into the employee in
qryComputeAppraisal. I want the managers to see only the employees within
their department. I found a function that pulls in the login ID of whoever is
logged at the time. I use this login ID in the record source of the combo box
to show only those emplloyees that are in the manager's department. This
works fine when the manager is entering data. When a manager uses Find to
find a record however, he or she is still able to pull up any record,
including those from other departments. Is there a way to hide all employees
from outside the department of the manager currently logged in? Am I going
about this the right way? Any help is greatly appreciated!
I have a database that is used by the managers of several departments of a
company. The database stores information about the performance of the
employees in each department. I have a query that computes averages from
information about each employee entered by each manager. The managers enter
the data into a form with a query called qryComputeAppraisal as its record
source. To keep data integrity, I have a table called Employees with the
employee names. A combo box in the form uses this table as its record source.
The employee name when entered is then put into the employee in
qryComputeAppraisal. I want the managers to see only the employees within
their department. I found a function that pulls in the login ID of whoever is
logged at the time. I use this login ID in the record source of the combo box
to show only those emplloyees that are in the manager's department. This
works fine when the manager is entering data. When a manager uses Find to
find a record however, he or she is still able to pull up any record,
including those from other departments. Is there a way to hide all employees
from outside the department of the manager currently logged in? Am I going
about this the right way? Any help is greatly appreciated!