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:
![]()