dynamic reports 1

[cynaptic]

is it possible to the query by form method of searching for records to produce a report. i.e. query by report where the criteria are user inputs.

any resources suggestions?

 

[pcdaveh]

Yes you need to use a parameterized or parameter query. You can reference in the criteria section of a query a forms listbox or textbox, combobox etc... in this fasion

[Forms]![NameofMyForm]![TextMyText] Something like that would go in the criteria of the query. At run-time the user would enter the parameters and either have a button on your specified event the process would fire.

 

[cynaptic]

pcdaveh

Thanks for that - works great!