I have user security level setup with username and password
I have set forms and tables etc to security levels
what i am having trouble with is setting user security levels to command buttons on the switchboard.
Example if you sign in Mary Jones
and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.
Code:
Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 2 Then
MsgBox "you cant open this form"
Cancel = True
DoCmd.OpenForm "TomsSwitchboard"
Me.Visible = False
End If
End Sub
Error; Tom's switchboard is not a form
it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..
when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.