Report prompts for date range too many times

[Timberwolf]

I have a report that contains five subreports. The query for one of the subreports contains a date field that prompts for the date range for the subreport. This is the only field in the entire report (meaning the main report and all five subs) that asks for a prompt. When I run the report, it prompts more for the date range three times. (If I run just the query, it only prompts me once.) Also, when I respond to each prompt with the same date range, the query/report retrieves the correct records. I can't figure it out! Ack!

Thanks!

Ann

 

[Pat Hartman]

One way to solve this problem is to create a form with unbound text boxes to gather the parameters and a button to run the report. Then you would change the prompts in the queries to reference the text boxes on the form instead of prompting. To reference a form field in a query:

....
Where YourField = Forms!YourFormName!YourControlName;

 

[Timberwolf]

Ahhhh! I get it!

Would I have two fields in the form - one for the beginning date of the period and one for the ending date?

Thanks so much!

[This message has been edited by Timberwolf (edited 08-02-2001).]

 

[Timberwolf]

Just bumping this up. Thanks.

 

[Pat Hartman]

Yes, use a separate control for each date.