Query by Form to Report

[funkygoorilla]

Hi,


I created a dialog form where a user can enter parameters into a query. I tested this and it works just fine, but I would like to know how to get this process to instead of opening the query results in a datasheet view, how to get it to open in the intended report? Basically I would like it to be as easy as putting in the query parameters in the form, then click OK, and then the report opens. Is this possible?
Thanks in advance, FunkyG.

[pbaldy]

Most of my reports are based on queries that get parameters from forms. Have you tried creating a report based on the query? Personally I have a button on the form open the report if the criteria have been properly entered, but some people open the form from the open event of the report.

[funkygoorilla]

Hi, I have succesfully created a report that uses a query to get information. My goal of that is to reduce the amount of information the user would have to enter in the parameters. hence why I chose to go form based. I think clicking an "Ok" button would be awesome, but how do I set it up to use the criteria selected in the form?

[pbaldy]

I thought the query already got parameters from the form? In the criteria row:

Forms!FormName.ControlName

[funkygoorilla]

My query does get the parameters from the form, but I want the end result to display my original report and not the query.
Here is one of my parameters;
[Forms]![frmQueryByForm]![txtSenID]
It is basically a text box. Currently when I hit Ok on the form, it opens the query results, but I would like it to open the report. Sorry if I am not being to clear on this.

[pbaldy]

Maybe I'm not being clear. Create a report that uses that query as it's record source. Then open the report rather than the query (the macro or VBA code would be OpenReport instead of OpenQuery). The report runs the query itself in the background.

[funkygoorilla]

If I choose to open the report, can I do so while using the criteria from the form?

[funkygoorilla]

Ok, so after reading your last post a couple hundred times, I figured it out. But, the report auto prints right away. Any idea how I can get it to just show?

[pbaldy]

One of the arguments of OpenReport determines whether it prints or previews. The default is to print, so leaving out that argument will cause it to print. Check help on OpenReport to see the correct syntax.

[funkygoorilla]

OK I got it. Its acViewPreview. Thanks for the guidance!

[pbaldy]

Happy to help!