NNiicckk
asked on
Access 2010 hide form/switchboard after open form selected
On my Home page (Switchboard) "On Open" event I would like to close the form after the selection is made for R100, S100 or M100.
Here is current code:
Option Compare Database
Option Explicit
Private Sub Form_Open(Cancel As Integer)
If Forms("frmLogin").txUserLe vel = 1 Then
Me.R100.Enabled = False
Me.S100.Enabled = False
Me.M100.Enabled = True
ElseIf Forms("frmLogin").txUserLe vel = 2 Then
Me.R100.Enabled = False
Me.S100.Enabled = True
Me.M100.Enabled = False
ElseIf Forms("frmLogin").txUserLe vel = 3 Then
Me.R100.Enabled = True
Me.S100.Enabled = False
Me.M100.Enabled = False
ElseIf Forms("frmLogin").txUserLe vel = 6 Then
Me.R100.Enabled = True
Me.S100.Enabled = True
Me.M100.Enabled = False
End If
End Sub
Here is current code:
Option Compare Database
Option Explicit
Private Sub Form_Open(Cancel As Integer)
If Forms("frmLogin").txUserLe
Me.R100.Enabled = False
Me.S100.Enabled = False
Me.M100.Enabled = True
ElseIf Forms("frmLogin").txUserLe
Me.R100.Enabled = False
Me.S100.Enabled = True
Me.M100.Enabled = False
ElseIf Forms("frmLogin").txUserLe
Me.R100.Enabled = True
Me.S100.Enabled = False
Me.M100.Enabled = False
ElseIf Forms("frmLogin").txUserLe
Me.R100.Enabled = True
Me.S100.Enabled = True
Me.M100.Enabled = False
End If
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.