Am working with an old Access database which utilizes Users and Groups Permissions.
Is there a way to make one of two forms open when the user logs in depending on that user's login?
I'm already using this code to determine the user:
If DBEngine.Workspaces(0).Users(CurrentUser).Name = "Shop" Then
blah, blah, blah
If the user is "Shop" then I want a particular form to open. If it's any other user then I want another particular form to open.