Cancelling a filter problem

azgambit

Registered User.
Local time
Today, 12:40
Joined
Apr 11, 2002
Messages
28
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!!!
 
Can I see the code?. I think that what you are doing is closeing the form before asking for the input
 

Users who are viewing this thread

Back
Top Bottom