Query to Form to Report

[DaveyB]

Hi All-
I have been looking for a simple way to take the results of a parameter query
which are displayed in a form, and view/print them in a report via a command
button on my form. I would like to have ALL of the records that the query
pulls on the report, not just the current record displayed on the form. It
seems like there should be a couple of lines of code that should do the trick,
but after much searching through the forums, I still cannot find out how to
do this. Just to clarify- I am relitvely new to Access programming, and
cannot do much more than the very basics with VBA. Any info is much
appreciated- thanks!

 

[Duane Hookom]

This is another good reason to avoid parameter prompt queries. Use controls
on forms for all user interaction. The values will persist so you can use
them in the form and then the report.

 

[DaveyB]

So if I follow you Duane, I should be setting up something like a set of
combo boxes on a form to select the values I want displayed (in the same form?
), and then generating a report from that?