How to create confirm message to do action in MS Access?

Use next VBA code into any event  ..

Response = MsgBox(prompt:="Are you sure to delete this invoice .. ", Buttons:=vbYesNo)
    If Response <> vbYes Then Exit Sub

'your next action after confirm message like...
    DoCmd.RunMacro "xxxxxx"

Enjoy ..

You may also like...