Same form, different controls per user

[Robster]

Is it possible to have a form and dependant on the security level of the user, will depend on what control will appear?
Or can I have the controls there and lock them to a user?

I have a DB of staff directory and I want to lock it so users can only view information, supervisors can edit and admin have full control.

I've done it so far by creating a different form and controls for each level but it a lot of work and queries.
Is there a simpler way to do it?

Thanks

 

[Robster]

Thanks Gizmo.
How do I go about doing that?

 

[Robster]

thanks but what I was asking is how do you control user s permissions on a form?
I have 3 user levels and i could use the same form but i want them to have different abilities.

EG. Open a form that has a combination of text boxes and subforms.
I want user level 1 to be able to edit the text boxes but user level 2 and 3 not to be able to edit the text boxes and subforms.

 

[burrina]

Without knowing your Security setup it is impossible to answer. Here is an Example that may help: Looking up the Users Security Clearance (Administrator) and Enabling a Command Button.

'Enable/Disable Administrator Command Button.
If DLookup("[admn]", "tblUserSecurity_Sec", "[userID]='" & Me.txtUserID.Value & "'") = -1 Then
Me.cmdadmin.Enabled = True
Me.cmdadmin.Visible = True
Else
Me.cmdadmin.Enabled = False
Me.cmdadmin.Visible = False
End If

HTH