cancel deletion error

[shrive22]

Here is my problem: I have two forms. THe first one is a snapshot of the data but is has a delete button on it. The delete button calls a macro that opens my second form which is a dynaset, then it closes the first form, then runs the command delete record, then closes the form. In the OnDelete event of my second form I have a macro ConfirmDelete which gives the user a msgbox to either click ok or cancel. When you delete a record and clikc ok to the confirm it works fine but if you click cancel then I get an error "Action Failed"-runcommand which is the command to delete the record

any ideas on how to get rid of this error??

thanks

 

[shrive22]

I think the error arises because the first macro is triggering the second OnDelete Macro and then when I cancel that it says that one of the actions in the first macro failed.

Still not sure how to fix it?