Working on a db for use by, well, idiots. I've developed a form with a command button that executes a filter based on entered parameters and sends the results of the filter to a report and closes the form.
Here's my problem, after clicking on the command button, the parameters box comes up just fine. However, if I click the <CANCEL> button on the parameters box, it exits the db.
No, this is bad. Is there anyway to set it up so that when the <CANCEL> button is clicked it will simply revert back to the form?
I would prefer to be able to do this within the filter query without a whole lot of VBA scripting. For some reason, no matter how hard and often I try I have all sorts of problems when I try to VBA script.
Thanks everyone!!!
Here's my problem, after clicking on the command button, the parameters box comes up just fine. However, if I click the <CANCEL> button on the parameters box, it exits the db.
No, this is bad. Is there anyway to set it up so that when the <CANCEL> button is clicked it will simply revert back to the form?
I would prefer to be able to do this within the filter query without a whole lot of VBA scripting. For some reason, no matter how hard and often I try I have all sorts of problems when I try to VBA script.
Thanks everyone!!!