Report prompting for parameters after form is cancelled

[Xcalibur]

I have a report where you enter the criteria via a form, it works fine, except when you close or cancel the form it continues to prompt for the criteria as if you were running the report without the form. It only prompts for the criteria that hasn't had any data put in it through the form.

ie. If the user runs the report and then changes their mind, they would press the cancel button on the form and it will close the form but then the prompts come up individually for each criteria required and the user has to press cancel on the criteria prompts also.

ie. it prompts for each criteria individually such as [enter start date] etc...

Any solutions as to how to prevent it from prompting after the form is closed?

 

[statsman]

How are you running this application?

On your form to enter the parameters there should be two command buttons. One opens the report after you enter your parameters. The second should just cancel, that is close the parameter form and do nothing else.

It sounds like you have included the cancel function in the actual report application and forgotten to tell the application to stop once the cancel button is clicked.

 

[Xcalibur]

How are you running this application?

On your form to enter the parameters there should be two command buttons. One opens the report after you enter your parameters. The second should just cancel, that is close the parameter form and do nothing else.

It sounds like you have included the cancel function in the actual report application and forgotten to tell the application to stop once the cancel button is clicked.

The report opens when you hit the ok button. I also have a command button to cancel the form. I have tried using the close and cancel commands but it prompts for the parameters whichever one I use. Do you have another suggestion of how I can program the cancel button?

Thanks.

 

[statsman]

Put a third button on the form (just to see if it works). Set it to "Close Form" and nothing else.
If it closes the form without asking for parameters...great. Just replace the old close form button with the new one.
If the new button is still asking for parameters, you'll have to go back and check the macro, query or code that is calling the form and see where you erred.

How is the form opened? Are you using a menu or switchboard? If so, the command on the menu or switchboard should just be to open that form. The macro or code you are using to find the data for your report and then create the report should be triggered by clicking OK on the search form, not from the menu or switchboard.