Running A Update Query from a Macro

[Sailesh Mistry]

When I run a update query (using OpenQuery in a macro)which prompts the user to enter a date, if the user selects to CANCEL, an action failed error message is displayed,

However if the update query is ran standalone and the user selects cancel it stop ok.

How do I stop the error message and close the query correctly via the macro?

 

[brucesilvers]

Have you tried adding the action "SetWarnings" (Argument=Warnings On: No) to the beginning of the macro? That should turn off all warning messages.

[This message has been edited by brucesilvers (edited 05-11-2001).]