View Full Version : Including a query paramter in a report


jaxxstorm
03-13-2007, 10:16 AM
I've designed a report based on a query, and all works fine.
I want to include the parameter that is entered before the report is displayed on the report.

I've tried using a textbox filled with =Reports![report name]![paramtername]

but an error is displayed? Is this because the original parameter is actually in a query and not a report?

Any help?

boblarson
03-13-2007, 10:26 AM
Normally, you build a form which has the controls where you set the parameters, the query underlying the report references those controls in the criteriaof the query and the report is just based on the query. If you want to refer to a control's value (maybe show the dates selected) you would use the form (needs to still be open) control in the report by referencing it by:

=Forms!YourFormNameHere.YourControlNameHere