By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,687 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,687 IT Pros & Developers. It's quick & easy.

unhide/hide controls tab for different users

P: 1
i have created the login form for different users. the user must enter the username and password if both of this are correct the Grant form will open. the grant form has the tab control with 4 pages.If its user1 the Grant form must show only 3tabs and if is other users it must show all the tabs.
ive try this code

Dim frm As New Exe
If Me.StrEmpPassword.Value = "xoliswa" And Me.StrEmpName.Value = "xoliswa" Then
DoCmd.Close acForm, "Login Form", acSaveNo
DoCmd.OpenForm "Exe"
frm.Page4.Visible = True

ElseIf Me.StrEmpPassword.Value = "linda" And Me.StrEmpName.Value = "linda" Then
DoCmd.Close acForm, "Login Form", acSaveNo
DoCmd.OpenForm "Exe"
end if
May 3 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.