Going back to form after Parameter Value form is cancel

[CAM]

Hello,

I have a form called "Policy" that contains a search button when pressing
the button a Ener Parameter Value pops up (from a query) my problem is if
the user press cancel or close the Parameter Value the "Policy" form closes.
I don't want the form close at all if the user decide not to use the
Parameter form. How can I program that the Policy form does not close?
Thank you in advance.

 

[Guest]

Hi CAM,

Show the code for the click event procedure of the search button on your form.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Warrio]

You have to use your own form to ask for your parameter value, because if
you count on the Access's default form, you can't have other result then
closing the main if the user presses on cancel
whereas if you make your own form, you can have the freedom to do what ever
you want if he presses on cancel

best rgds