B
brem219
Good morning,
I have user security on a workflow database with a manager and five
subordinates. The manager is the only one with Admins privileges. He is the
only one that has the ability to look at his own work items and the work
items of the subordinates. The Main form verifies if the user is a
CurrentUser, so it can tell if the manger is using the form. I have a combo
box where the manager can select the name of the employee and push a button
that opens an editing form. The form runs a query that pulls in that
employee’s work items. The problem is that the query is coming up blank.
Here is the SQL:
SELECT....
FROM [Main Table]
WHERE ((([Main Table].Username)=CurrentUser()) AND (([Main
Table].Director)=[Forms]![Main]![Combo2]))
WITH OWNERACCESS OPTION;
Thank you.
I have user security on a workflow database with a manager and five
subordinates. The manager is the only one with Admins privileges. He is the
only one that has the ability to look at his own work items and the work
items of the subordinates. The Main form verifies if the user is a
CurrentUser, so it can tell if the manger is using the form. I have a combo
box where the manager can select the name of the employee and push a button
that opens an editing form. The form runs a query that pulls in that
employee’s work items. The problem is that the query is coming up blank.
Here is the SQL:
SELECT....
FROM [Main Table]
WHERE ((([Main Table].Username)=CurrentUser()) AND (([Main
Table].Director)=[Forms]![Main]![Combo2]))
WITH OWNERACCESS OPTION;
Thank you.