i have various forms. admin has all rights,
mgr has some rights (edit/add)
user has little rights: view only, no add,delete, etc
i capture user ID when the main form opens (users dont see it)
then look up his rights in the tUsers table.
Private Sub Form_Load()
txtUser = getUserID()
txtRights = dlookup("[rights]","tUsers","[userid]='" & txtUser & "'")
Public Function getUserID() As String
getUserID = Environ("Username")
then the user clicks button on the menu, the logic opens THAT form.
select case me.txtRights
or you could just set the restrictions on a single form, depending on the user rights.