Deletion confirmation message

  • Thread starter Thread starter Audrey
  • Start date Start date
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!
 
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
 
Back
Top