Hi there -
Please help, yes I am begging.
I am using Access 2007 and this is my first db. I created a login form for Analyst to enter Access to enter the work hours and tasks.
The table (Analysts) consists of:
Username, Password and Privilege
Now, when a user logs in using their username and password, I want the code to find the 'Privilege' assigned to the Username and opened a particular form.
Privilege A - I want the Form 'Privilege A Form' to open. For Privilege B - I want the code to find and open 'Privilege B Form. I want this to happen for 5 different Privileges I have assigned to different Usernames in the Analyst table.
This is where i start and end:
If Me.Username = DLookup("Username", "Analysts", "Privilege=A") Then
DoCmd.OpenForm "Privilege A Form"
Else
Thanks!!!
Please help, yes I am begging.
I am using Access 2007 and this is my first db. I created a login form for Analyst to enter Access to enter the work hours and tasks.
The table (Analysts) consists of:
Username, Password and Privilege
Now, when a user logs in using their username and password, I want the code to find the 'Privilege' assigned to the Username and opened a particular form.
Privilege A - I want the Form 'Privilege A Form' to open. For Privilege B - I want the code to find and open 'Privilege B Form. I want this to happen for 5 different Privileges I have assigned to different Usernames in the Analyst table.
This is where i start and end:
If Me.Username = DLookup("Username", "Analysts", "Privilege=A") Then
DoCmd.OpenForm "Privilege A Form"
Else
Thanks!!!