Security Settings

[spaz9876]

I created specific users for my database with each user having their own switchboard. How can I make it so that their switchboard comes up when they log in?

[DarkSprout]

Select Case userID
Case 1
DoCmd.OpenForm "frm_User1Switchboard"
Case 2
DoCmd.OpenForm "frm_User2Switchboard"
Case 3
' etc...
End Select

or

'// Using "frm_User2Switchboard" format
DoCmd.OpenForm "frm_User" & userID & "Switchboard"

[DarkSprout]

...