Parameter Query

[Angelique21]

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. This query is stored in the control source of a sub-report in the Main report.

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

 

[PHV]

Use a parameter form instead of the query's builtin inputbox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Angelique21]

Can you please elaborate on this subject...

thanks