A less secure, but simpler way to warn users before changing data is to put the following code in the form?s Before Update property:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Const MsgStr = "***Warning*** You are about to make changes to data. " & _
"Click on Cancel, then press the [Esc] key to cancel changes."
If Me.NewRecord = False Then
If MsgBox(MsgStr, vbOKCancel) = vbCancel Then
Cancel = True
End If
End If
End Sub
Also look under the Dirty Property in Access help for another example of how to do this.
As far as deleting entire records, go to the Tools menu, Options, Edit/Find tab, and make sure the Record Changes check box under Confirm is checked.
This won?t keep users from changingdata in a table, but if they always use the form, it will warn them every time they make a change or deletion. To warn them when they make additions also, just remove the If Me.NewRecord = False statement.