Read Only Form

[tt1611]

Does anyone know of a way to load a form Read-Only based on a condition, Say for example if user is of type "User" then load form readonly else load form normally.

I know about the readonly property on the form property but that locks up the whole form regardless of who's viewing it and not on a per user basis

 

[boblarson]

All you have to do is to use code to figure out who it is and then adjust accordingly. For example:

Private Sub Form_Load()
   Select Case Environ("username")
   Case "billr", "samt", "ellenv"
       Me.AllowEdits = True
   Case Else
       Me.AllowEdits = False
   End Select
End Sub

But I would actually use a table to tell who has what but this is just a quick example.

 

[tt1611]

Hey Boblarson.
Thanks for that. I had just seen the allowedits property in code. I have used that and setup all access levels accordingly

Thank you very much for your help..