If you only want certain users to be able to see some of the controls, you can easily hide
and unhide individual controls according to the user level:
If ReturnUserLevel = "unknown" then DoCmd.Close
If ReturnUserLevel = "basic" Or ReturnUserLevel = "novice" Then
Me.Text1.Visible = False
Me.Label2.Visible = False
Else
Me.Text1.Visible = True
Me.Label2.Visible = True
End If
Do not forget that when hiding controls this way you also need to hide the attendant label
for that control.
This methodology provides a very good way of restricting users as to where they can go
and what they can do. Combined with Chapter 24, it provides a discipline over your
application.
Chapter 40: Set Up Levels of User Security 357