report from form help.

[bill crumpton]

I have a form that shows the results based on a select query. I would like to put a command button so that a report would print based on the information on the form. I've created a report based on the same query that the form is based on. However I need the report to be able to be accessed through the form. When I craete a command button to open report I get the same parameter prompt that I get when I open the form. Is there a for the Report to be previewed without prompting for that criteria again?

Thanks for all the help.

 

[Chris RR]

Make a copy of the query that you've based the report on. Change the copy so it picks up the criteria from the form, for example like this:

<=[Forms]![fMyWonderfulForm]![Report_date]

Point your report to this new query. If you run the report without the form open, your prompt will look pretty weird. But if the form is open (even if its minimized) the report should pick up the data just fine.

You may even find it useful to calculate and "hide" some fields on the form so that they can be used in reporting.