Can Query Parameters be displayed in a report?

[Joe B.]

I have created a form to enter a date range as parameters to a query. I then created a report from the query results. Is there a way to display the "To" and "From" dates entered into the form on the report?

Thanks for the help.

Joe B.

 

[pbaldy]

Sure, a textbox with a control source of:

=[Enter To date]

where the text is exactly the same as in the query. You can concatenate them both into a string if you want.

 

[Joe B.]

Thanks...I created the text box and entered =[Enter Start Date] into the unbound box. I then opened the form to enter the Start Date and clicked the button I set up to run the query and the report. However, after the query ran an Enter Parameter window popped up looking for the Start Date. Did I do something wrong? Any ideas?

 

[pbaldy]

If you're using a form for the parameters instead of the brackets method (my foolish assumption), then the textbox would be:

=Forms!FormName.TextboxName

 

[Joe B.]

Thanks...that worked. . .

 

[pbaldy]

No problem. Please tell me you edited the post to add the bit about the form, and I'm not a complete moron for missing that part.