I'm using a list box to open reports. One of the reports has 3 parameters that the user has to enter. Rather than having them type in the information, I'm using a form that has 2 combo boxes for the user to make their selections for 2 of the parameters. After the user enters the parameters, he/she clicks OK and the report comes up.This arrangement seems to work very well. The problem I'm having is when the user tries to cancel or close the form because they don't want to continue the process for some reason. The form will close but the parameters from the underlying query for the report pop up. I believe the close or cancel button on the form is in conflict with the instructions in the reports list box to open up the report.
I need to know how to close the "parameter" form without having the underlying query pop up.