Access OnDelete message

G

Guest

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.
 
K

Ken Snell \(MVP\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Event Timing OnDelete 4
No Show Delete Confirm popup 4
On Delete Msg Box 3
Access generated messages 1
Overriding constraint restriction message, when deleting record(s) from form 6
Intercept the Delete Key/Function on a Subform 3
Trapping messages with code 3
Form OnDelete Event Problem... 3

Top