cancel button

[Guest]

If when I run a macro that involves opening a query that has a parameter
value to be entered and I press the cacel button on the parameter input box,
how do i prevent the message the tells me the macro is being halted.

Once i press cancel i just want to go back to the form,

or can this be done in code?

 

[Steve Schapel]

Sorry, Patrick, as far as I know this is not possible.

An alternative approach is to open your own form with a textbox for the
entry of the query criteria. That way you have control over what
happens when any button on the form is clicked.