prompt queries and subreports

[Becki]

I have a subreport made from a query that uses a prompt.
When I run the subreport by itself, the prompt comes up
one time and it all works fine. When I run the main
report which uses the subreport, the prompt comes up for
each record (Hundreds of times). What have I done wrong?

 

[Duane Hookom]

Try to avoid using parameter queries. Using references to controls on forms
is much more powerful and flexible. If you want to specify a date range, use
a criteria like:
Between Forms!frmX!txtBegDate AND Forms!frmX!txtEndDate