parameter query prompting multiple times

J

JohnLute

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!
 
J

jl5000

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top