ok i have now sorted it thanks anyway for looking
ok this is what i want to do
the following code enables or disables a command button on page open depending on the users access level
Private Sub Form_Open(Cancel As Integer)
Select Case User.ViewID
Case 1, 2
Me.Command117.Enabled = True
Case Else
Me.Command117.Enabled = False
End Select
Exit_Form_Open:
Exit Sub
Err_Form_Open:
MsgBox Err.Description
Me.Visible = True
Resume Exit_Form_Open
End Sub
what i would like to achive is to have 2 command buttons contolled by the code but i cant seen to figure out how to do it
yhanks for any help
rob
ok this is what i want to do
the following code enables or disables a command button on page open depending on the users access level
Private Sub Form_Open(Cancel As Integer)
Select Case User.ViewID
Case 1, 2
Me.Command117.Enabled = True
Case Else
Me.Command117.Enabled = False
End Select
Exit_Form_Open:
Exit Sub
Err_Form_Open:
MsgBox Err.Description
Me.Visible = True
Resume Exit_Form_Open
End Sub
what i would like to achive is to have 2 command buttons contolled by the code but i cant seen to figure out how to do it
yhanks for any help

rob
Last edited: