Condition required for cancelled Query in a macro

[Colin G eastwood]

Hi There
I am running a Macro from within a Form, the Macro opens a
Parameter-query', if a user selects cancel from the query's input
pop-up-box, is there a condition being met, that I could make my Macro
recognise, to bring the 'StopAllMacros' command into play.
Kind regards
Colin G Eastwood
--

 

[Steve Schapel]

Colin,

As far as I know, you can't do this in a macro. Instead of a Parameter
Query, use a simple unbound form with a textbox where the user can enter
the required data, and then in the Criteria of the query, replace the
parameter prompt with a reference to the textbox, using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]
That way, you can assign your macro on a Command Button on this form,
and also a Cancel button on the form which simpy closes the form when
clicked.

 

[Colin G eastwood]

Colin,

As far as I know, you can't do this in a macro. Instead of a Parameter
Query, use a simple unbound form with a textbox where the user can
enter the required data, and then in the Criteria of the query, replace
the parameter prompt with a reference to the textbox, using syntax such
as...
[Forms]![NameOfForm]![NameOfTextbox]
That way, you can assign your macro on a Command Button on this form,
and also a Cancel button on the form which simpy closes the form when
clicked.

Thanks Steve
That works fine.
Kind regards
Colin G Eastwood
--