Reports and input params.

[Bob]

Hi,
I have an app that I'm adding reports to.
The button that opens the report, chages the InPutParameters
so that the stored proc can pull the data.

My question is this. When the user closes the report, the prompt
to save is displayed. How can I chage the params on the report
when opening it, then either save it, or not save it so that the user
does not get the prompt every time.

I'd tried using DoCmd.Save acReport
but can't seem to get this working.

thanks in advance,
bob.

 

[Sylvain Lafontaine]

The best way is not the change the InputParameters and instead of using
constanst, use references to controls on a form or public/global variables
on a module, something in the line of:

@IdRoute int = Forms!d_Rapports!ComboIdRoute, ....

 

[Bob]

Thanks Sylvain!
You've made my problem go away.
I really appreciate the reply and the solution.
Bob.