Parameter Value Cancel button

[Darkladymelz]

I have created a query with parameter values, which work fine.



My database opens and closes forms via a macro button. when I click on the button to open the query with the parameter values it automatically closes the form that the button appears on (this is what I want to happen).

My problem is, for instance, if I decided I do not want to open this query and I press 'Cancel' on the parameter value box the box closes and I am left with an empty screen. Is there a way for me to be able to press the 'Cancel' button and it re-open the form it was on before?

Below are screenshots of the process:

[June7]

That input popup is generated by a parameter prompt in query? I don't use query input parameter prompts just for this sort of reason. The input cannot be validated and it is not available to code for further processing. I use controls on forms for parameter input and validation. The parameter in query would refer to the control on form for input value. Then code can check if value in control and if not there, do not run report and do not close form.