I figured it out, thanks though and Twinnyfo that was a good read. Thanks.
If strCBOPass = strPassword And strUsertype = "Administra tor" Then
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "Main_Form"
ElseIf strCBOPass = strPassword Then
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "Main_Form2 "
User Profile
Collapse
-
Enable / Disable MS Access Button
I need help with a vba code to only allow people who are logged in as Admin to be able to open a button called Manage Users and at the same time grey it out for people who log in as User. Thanks in advance for the help!
MS ACCESS 2013
No activity results to display
Show More
Leave a comment: