user security access 2013 for switchboard items

[LaughingBull]

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.

[June7]

I would disable the command button if Tom is not the user so they don't even get to the point of opening switchboard.

By 'switchboard' do you mean a form built by the switchboard wizard? Don't like it, never used it. There is good reason it has been deprecated.

[LaughingBull]

yes it is switchboard manager. so you would build all the switchboard forms from scratch?
what code would you use to disable the button?

[June7]

Yes, from scratch with VBA, not macros.

Possibly in the main menu form Open event, something like:

If Me.User <> "Tom" Then Me.buttonname.Visible = False

[LaughingBull]

What I did was on open put the code

Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 3 Then
MsgBox "you cant open this form"
Cancel = True
Form_Leslie.AllowDeletions = False
Form_Leslie.AllowEdits = False
Form_Leslie.AllowAdditions = True
End If
End Sub
The user table is not just 4 levels of security
each entry is one of the users and there are 7 users and each has different levels of security I am creating

so if column (4) = 1
then it is Mary that signed in
what I am trying to do is make this one step
so If column(4) is = to 1 or 4 then both users 1 and 4 can open the form and enter additions.
Can you help? not sure how to accomplish this.
Thanks

[June7]

I don't understand the structure so is hard for me to advise specifics.

I don't build different forms for different users. I build forms to meet a process requirements, not separate forms tailored to individual user.

I have one 'login' form and one MainMenu form for all users. I use code to manage what controls on form are available to users. If I don't want 'staff' users access to button A then I disable that button. Why allow user to initiate opening a form if they should not use that form?

User should not be able to get to objects in navigation pane.