Conditional switchboard based on user-security login

  • Thread starter Thread starter jeffceo
  • Start date Start date
J

jeffceo

Folks,

I would like to load alternative switchboars upon application startup,
based on the user's username and password managed by Access's
User-level security. I have to believe someone has done this before.
I know I can have a user open a different form based on a shortcut (not
secure), and I believe if I can trap the username, I could use it in a
conditional statement in an AUTOEXEC macro, but don't know how to
capture the username. Any help would be most appreciated!

Kindest regards,

Jeff Ceo
 
Hi,
you can use the CurrentUser() Function since you are using access build in
user level security...you can actually just do this on the on open or on load
event of you splashscreen form (if you have one)...e.g.:

If CurrentUser = "YourUserName" Then
DoCmd.OpenForm "Form01"
Else
DoCmd.OpenForm "Form02"
End If

HTH
Good luck
 
Back
Top