Access OnDelete message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ABM - 27 Oct 2007 15:48 GMT

How do you stop the Access message when you delete a record. I want to
create my own but can't figure out how to stop the Access delete confirmation
message.

Reply to this Message

Ken Snell (MVP) - 27 Oct 2007 16:58 GMT

You set the Response variable to the constant "acDataErrContinue" value in
the BeforeDelConfirm event procedure:

Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
On Error Resume Next
Response = acDataErrContinue
End Sub

Signature

Ken Snell
<MS ACCESS MVP>

> How do you stop the Access message when you delete a record. I want to
> create my own but can't figure out how to stop the Access delete
> confirmation
> message.

Reply to this Message