Limiting data that gets printed in a report

[Troubled]

I'm a raw novice but am creating a database system for a childrens hospital charity. Its going well but now I have got to reports. I have a database with a few thousand entries. I don't want the whole lot every time I run a report. I have built a multi-field search form and it works really well on a query as a stand alone thing. Please can anyone tell me how to incorporate this in a report. I have included the query name as the control source of my report but it doesn't work. It comes up with a box asking me to enter a parameter value instead of displaying my multi-field search form. Please tell me what I'm doing wrong. Many thanks

[CJ_London]

if you look at this link about docmd.openreport

https://msdn.microsoft.com/en-us/lib.../ff192676.aspx

you will see there is a parameter for 'where'

So rather than using parameters in your query, use vba to create the 'where' string

[John_G]

Just to add to Ajax's suggestion -

You could incorporate the report generation into the search form. Add a command button to the form to print the report, in which the "Where" part of the Docmd.Openreport command corresponds to the entries on the form.

[June7]

I concur - I NEVER use dynamic parameterized queries. Here is a tutorial for a search form http://www.allenbrowne.com/ser-62.html

[Troubled]

Thanks very much. Still struggling but not sunk yet. With more proplus and effort I will get there in the end - hopefully