parameter query prompting multiple times

I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach.

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. The Master/Child fileds
are setup properly.

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

--
www.Marzetti.com

JohnLute wrote:

I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach.

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. The Master/Child fileds
are setup properly.

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


You are being prompted each time the subreport appears in
the main report.

A better way is to use a form for the user to enter the
parameter value. Then modify the query to refer to the text
box on the form instead of using a prompt string (e.g.
Forms!theparameterform.thetextbox).

--
Marsh
MVP [MS Access]

Thanks, Marshall.

Not sure what you mean by subreport prompting for each time it appears in
the main report. The subreport appears only once yet it will prompt exactly 4
times.

?

--
www.Marzetti.com


"Marshall Barton" wrote:

JohnLute wrote:

I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach.

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. The Master/Child fileds
are setup properly.

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


You are being prompted each time the subreport appears in
the main report.

A better way is to use a form for the user to enter the
parameter value. Then modify the query to refer to the text
box on the form instead of using a prompt string (e.g.
Forms!theparameterform.thetextbox).

--
Marsh
MVP [MS Access]

JohnLute wrote:
Not sure what you mean by subreport prompting for each time it appears in
the main report. The subreport appears only once yet it will prompt exactly 4
times.


I would have guessed the the subreport was in the detail
section and that the main report has 4 records.

Regardless of why, you are better off using a form for the
user to enter the criteria.

--
Marsh
MVP [MS Access]

"Marshall Barton" wrote:

I would have guessed the the subreport was in the detail
section and that the main report has 4 records.

Regardless of why, you are better off using a form for the
user to enter the criteria.

--
Marsh
MVP [MS Access]


The subreport is in the detail section but the main report is only opening
one related record.

Thanks for the form suggestion. I'll have to experiment with that.

I saw this post and lit up! I'm having a similar problem with subreports
based on parameter query, however, I don't understand about the master child
fields.

My report is set up with one subreport (that will only return one value) in
the page footer section, another 2 subreports (returning multiple values) are
setup in the report footer section. All are run off of parameter queries.
They all have the date (warehouse load or unload) is common. The report
currently prompts 3 times to open the report.

Can I make this work for my situation?
Thanks,
Dragon
"Marshall Barton" wrote:

JohnLute wrote:

I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach.

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. The Master/Child fileds
are setup properly.

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


You are being prompted each time the subreport appears in
the main report.

A better way is to use a form for the user to enter the
parameter value. Then modify the query to refer to the text
box on the form instead of using a prompt string (e.g.
Forms!theparameterform.thetextbox).

--
Marsh
MVP [MS Access]