Parameter Query

[vanny]

Hi All,

I have an Order Form that when the user chooses to Preview the Order Report ; a Parameter Query will pop up, asking the user to enter his Initials if he wants to have a Scanned Signature (stored in a folder as jpg) on the Order.

In the Order Report Menu I have created a button that the user can choose in order to send the whole Report in Snapshot Format to the Client. The problem is that when the user chooses this button, the Parameter Query pop up is once again shown.

My idea is to prompt the parameter query only once at the Report stage before converting it to snp.


Any suggestions, pls of how I can go about this!!

Thanks

 

[burrcm]

Use the button to open a pop up form. Enter the parameters here. An OK or whatever button on the form fires the required events and the parameters remain available. Last thing you do is close the form.

Chris B

 

[vanny]

My problem basically is that from the FORM ORDER to the REPORT ORDER the user is linked to the parameter query asking the user to input his intials to view the signature on the report. Then if the user wants to send the ORDER REPORT to the client by email, i made a button that will call the same report but convert it to snp. and here once again the user has to enter his initials, cause there is one parameter query linking the same report at different stages

 

[burrcm]

You can enter all parameters on the form and reference the queries back to it - e.g. a text box on a form (Form1) called Input1 would be referenced in the query criteria as =Forms![Form1]![Input1]. You might use this just for the initials, but use normal parameters in the query for the rest, or put it all on the form.

Chris B