unhide/hide controls tab for different users

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xollie
    New Member
    • Apr 2010
    • 1

    #1

    unhide/hide controls tab for different users

    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.StrEmpPasswo rd.Value = "xoliswa" And Me.StrEmpName.V alue = "xoliswa" Then
    DoCmd.Close acForm, "Login Form", acSaveNo
    DoCmd.OpenForm "Exe"
    frm.Page4.Visib le = True

    ElseIf Me.StrEmpPasswo rd.Value = "linda" And Me.StrEmpName.V alue = "linda" Then
    DoCmd.Close acForm, "Login Form", acSaveNo
    DoCmd.OpenForm "Exe"
    end if
Working...