Supress Action Failed on Cancel of Append Query Dialog Prompt

[meagain]

Hi All,

Is there anyway to instruct a MS Access (2002) application how to respond to a user pressing cancel from an Append Query criteria dialog prompt? The Append Query is executed from a macro.

When the users press Cancel now, they receive an Action Failed window. Would prefer the Action Failed window did not appear in this instance.

Thank you,
LP

 

[LaurieHamlin]

Thanks for including which version you're using. Is there an error number with the message?

 

[LaurieHamlin]

Oh, obviously:
On Error GoTo Err_Command0_Click in the on click code before the rest of the code

at the end
Err_Command0_Click:
Resume Exit_Command0_Click