Deletion confirmation message

A

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!
 
A

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
 
Top