parameter query prompting multiple times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter query in a subreport that works fine. However, when I add
this subreport to the main report and execute it the parameter query prompts
me four times before it finally returns the report.

I can't see where/why this is happening. Any ideas?

THANKS!
 
Here are 2 options, (there can be more, but let's keep this simple)
Option 1:

1.Create 1 text box in the main report for each parameter
2.Name the text boxes the same as the parameters (Control Name)
3.Once you enter the parameters, the values will be stored in these text
boxes and used by the sub-report

Option 2:
1.Create a form that receives the parameters from the user
2.Link the main report record source and the sub report record source to the
form's parameters in the criteria,
 
Back
Top