Role Based Access to Edit

[rch918]

I am looking for a way to give certain users, based on their Employee ID Type (1=Administrator, 2=Staff, etc.) the ability to edit specific fields in a form. I want all users to be able to view the column/fields but only level 1's can edit it. I have tried the following code with no success.

 If EmployeeType_ID = "1" Then
Me.MHMD_Dept.Enabled = True
Me.ACO_Member.Enabled = True
Me.MHMD_Dept.Locked = False
Me.ACO_Member.Locked = False
Else
Me.MHMD_Dept.Enabled = False
Me.ACO_Member.Enabled = False
Me.MHMD_Dept.Locked = True
Me.ACO_Member.Locked = True
End If
End Sub

I do not have the Employee Type ID field in the specific form as it's based on each users log-in.

[andy49]

Store the employeetype_id as the caption on an invisible label?

I presume you've set up some sort of system to identify it?


Sent from my iPhone using Tapatalk