Easy One: How do you display the Parameter Input?

[NICOLE2000]

Hello,

When you create a parameter-driven query (one that prompts the user to enter a condition, say a date range) how do you get that users input (here, the date) to display on your report?

Thanks in Advance!!

[Edneeis]

What do you mean? What are you using? ADO? Access? If you are just using straight Access then put the following in the query that your report pulls from:
In the Criteria section just put' =[What do I want to prompt the user for here]

If you are using something like the data environment in VB then just put a Textbox or whatever on the form and then when you execute the query use:
de.qWithParam Text1.text

[NICOLE2000]

Edneeis,

Thanks for replying. I am using Access 2000. The query asks the user to enter a "date range". That part works. But what I need to know is, how do I get the "date range" that the user entered into the query to display on the report? When the user runs the report, and the query prompts them to enter a date range, I need the report to show that date range. That way, the user will know what date range the report was run for. Can this be done? Thanks for your help!!

[Clunietp]

I've done that before...it sounds easy, but it was difficult to get the variables into the report...

I eventually used the MIN and MAX functions of my date field to show the date range for the report

Hope this helps

Tom

[andreww]

If it's any help I did this within the onload event of the report using VBA to prompt for the variables and passing this through to the query - sounds simple but took a bit of playing with to get it right