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
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