Deletion confirmation message

[Audrey]

Hi,

I created a delete button using the wizard. How can I
change the deletion confirmation message and use my own
instead?

Thanks for helping out!

 

[Andy korth]

Yup!
Here's what I do:
Response = MsgBox("Are you sure you want to delete this
record?", vbYesNo, "Delete this Record?")
If Response = vbYes Then

DoCmd.SetWarnings False

'some delete code here

DoCmd.SetWarnings True

end if

The setwarnings command will supress the standard warning.

HTH
Andy