Show Prompted Criteria on Report (1 Viewer)

[MsLady]

I have a criteria in my report that prompts the user for input when they open the report.

I just have [Enter date] on the query criteria the report based on.

I would like to show the "entered criteria" on the report when the report is open. Can someone tell me how to?

I'd like a heading label on my report to read:
Records for [date]

I am aware that i could put textboxes on a form and have it get the value from that "=Forms!YourForm!textbox" but that's not what i want. This has nothing to do with a form.

I want to open the report straight from the report's object window, enter the criteria when prompted and print the entered criteria on the report's label.

Please help?

 

[pbaldy]

Try a textbox with a control source of:

="Records for " & [Enter date]

 

[boblarson]

inaccurate information removed

 

[pbaldy]

I do not think that Paul's suggestion will work as it will result in you getting two prompts for date.

Your confidence in me is under-whelming. As long as the text in the control source brackets exactly matches the text in the criteria brackets, you will only get one prompt.

 

[HiTechCoach]

I don't think you are going to get this to work your way (and that is 12 years of working with Access talking).

Bob,

Paul's suggestion really does work and does NOT prompt twice. I learned how to do this back when using Access 2.0! When asking for a date as parameter, I prefer to use a form so that I can use a calendar and also validate the data, but not required.

See:
How to Print Microsoft Access Query Parameter values onto your report:

 

[MsLady]

Try a textbox with a control source of:

="Records for " & [Enter date]

Thank you pbaldy, it works like charm

Thank you all for your time *muah