Showing query parameters on report

[Kraybald]

Hi All

Am relatively new to access so go gently on me...

I have a set of reports that run off queries with multiple criteria, one of which are date parameters to be prompted by the user. I would like if possible to have the start and end date they have chosen show on the top of the reports...

Can you help?

Many thanks

 

[chergh]

This should show it:

currentdb.querydefs(the_query_name).parameters(parameter_name).value

 

[boblarson]

You should really use forms to gather user input and not prompt from the queries themselves. It gives you a whole lot more control and you can reference the form control values in the reports (as long as the form remains open).

 

[teel73]

This should show it:

currentdb.querydefs(the_query_name).parameters(parameter_name).value

Where would you put this statement? In the control source of a control? I'm trying to do the same thing.

 

[Brianwarnock]

The usual technique is to use a form togather the user input eg startdate enddate and then use a command button to fire off the report, the controls on the form are accessible to the report as long as the form stays open, just to repeat what Bob said, thus a control in say the reports header can have as its source =Forms!formname!controlname.

Brian