Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using parameter query as report source

Status
Not open for further replies.

galar

Programmer
Feb 19, 2002
59
IL
Hi,

I often need to make reports to which i need to pass at least 4 parameters.
I want the user to see the request for the parameters placed on one form. After user will fill in all his requirements, he will click the "Show" button and recieve the desired report.
Now, I just pass all those parameters as a "where condition" to the OpenReport line, but it's seems to me that I must have a way to use the parameter query as a Report source and when the user will click the button the values will be given to the appropriate parameters. I haven't succeeded to make it work.

Any suggestions?

Thanks in advance.
 
Since you've already written then OpenReport command with the proper criteria, you no long need the parameters in your query. You can take them out of the query and just use a regular select query for your report record source. Maq B-)
<insert witty signature here>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top