prompt queries and subreports

  • Thread starter Thread starter Becki
  • Start date Start date
B

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?
 
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
 
Back
Top