Cancelling query launched from macro

[Larry]

-----Original Message-----
I'm using a command button on a form to launch a macro,
which in turn opens a query. That's because I don't see
an option to directly launch a query from a command
button, without the intermediate step of using a macro to
open the query. I imagine launching a query directly from
the button can be done in VBA code but I don't know how.

My problem is this. The query has a built in prompt (text
in brackets under "criteria" in query design view) which
opens a little dialog box that prompts the user to enter
which Order Number to search for in this case.

The query runs fine when opened *directly* without the
intermediate step of using a macro to open the query, in
that I can click on cancel when the dialog box appears,
and the action cancels without an error message.

The query also runs fine from the command button's macro,
with one exception. If you click on cancel when the
dialog box appears prompting for Order Number to search
for, there is an error message window titled "Action
Failed" which pops open.

In the Action Failed window it has the following lines:

MacroName:
macFindOrder

Condition:
True

ActionName:
OpenQuery

Arguments:
qryFindOrder, Datasheet, Edit

It's a minor inconvenience because you can simply close
this error message window and go on happily about your
business. But how do I make it so the query can be run
from a command button and cancelled without an error
message?

Thanks in advance,
Tom
.
Highlight the query and use the tools on the menu and go

to macros and convert the macro to code. Do not uncheck
the Add erro handing.......
Once this is done go to the form and on the buttons
properties event tab click on the drop down ... and select
code.
once VBA is open open the macro you converted and copy
everything after Private sub or function and before end
sub or function and paste this between the Private sub or
function and end sub or function on the cmdbutton for your
form