Macro Error



I am working with delete macro in a subform. It works well in deleteing the
information but if I decide not to follow through and hit cancel a window
show us stating action failed and in order to close window I have to hit the
halt button. What must i change in the macro for it to close with out taking
any action and not showing the halt window.
Private Sub Qtdel_Click()
On Error GoTo Err_Qtdel_Click

Dim stDocName As String

stDocName = "QtDelete"
DoCmd.RunMacro stDocName

Exit Sub

Resume Exit_Qtdel_Click

Steve Schapel


As far as I know, this is not possible.

However, you could prompt the user in advance to confirm if they are
sure they want to run the delete.

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