I want to not allow certain people to delete a record in a Form.
I know you can change the Allow Deletions, but it's not working. I think it's because the Form is in a Form.... Not sure.
I know I have user and group permissions, but it's not using that. It has an Employee Table for permissions. Everyone's under Admin.
So, I'm thinking my last option is code. I know I can add:
Private Sub Form_Delete(Cancel As Integer)
Cancel = True
MsgBox "This record can't be deleted."
End Sub
But, I don't want to lock out everyone. Just want one or two people to be able to have this access. So I tried:
Private Sub Form_Delete(Cancel As Integer)
If AccessManagment Then
Cancel = False
If Cancel = True Then
MsgBox "You cannot delete this record"
End Sub
As I figured, it's not working. AccessManagment is a column under the Employee Table
Thanks for the help