Currently, this is what I have setup:
Edit button only appears next to records if that person is Admin.
However, what I want to do is display the same button next to records tied to that user. So, in theory, if the user makes a mistakes and needs to adjust something they can, but they can't edit someone else's records.
Making the button work for a given user is no problem, but I don't want it displayed beside all records. Only those where that person name is in the record.
Code:
Dim UserLevel As String
UserLevel = Nz(DLookup("[Role]", "[Employee List]", "[Employee Name]='" & [TempVars]![CurrentUserID] & "'"), 0)
If UserLevel = "Admin" Then
Me.AdminEdit.Visible = True
Else
Me.AdminEdit.Visible = False
End If
Edit button only appears next to records if that person is Admin.
However, what I want to do is display the same button next to records tied to that user. So, in theory, if the user makes a mistakes and needs to adjust something they can, but they can't edit someone else's records.
Making the button work for a given user is no problem, but I don't want it displayed beside all records. Only those where that person name is in the record.