Problem with running prompt box query with macro

[Gurdeep Saini]

I have attached a macro to a query so that i can run it from a switchboard. The query is run fine but 2 error messages appear when cancle is selcted. How do i solve this?

 

[Rich@ITTC]

Hi Gurdeep Saini

Why not use a command button that directly runs the query? From the toolbox in design view for the switchboard you can select a command button and draw it in your form (with the wizard button on the toolbox being depressed). The Wizard then has "Other" as one of the choices (last one, from memory) on the left-hand pane and once selected you can choose Run Query. That way you avoid using a Macro at all.

HTH

Rich