Sub-reports causes multiple parameter prompts

[Jacques Latoison]

I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five reports
(two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add the
5 reports to one, as 5 sub-reports, the Parameter prompts the user 5 times.
Is there any way around this so the user is only prompted once?

Thanks beforehand,

Jacques

 

[Allen Browne]

Create an unbound form, with text boxes where the user can enter the values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]

 

[Jacques Latoison]

Sorry for not responding sooner.

There is only one query that feeds all 5 reports. Each report uses a
different piece of information.
and
One of the parameter prompts is in a query that the final query pulls from
(both prompts aren't in the same query).

Create an unbound form, with text boxes where the user can enter the
values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five
reports (two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add
the 5 reports to one, as 5 sub-reports, the Parameter prompts the user 5
times. Is there any way around this so the user is only prompted once?

 

[Allen Browne]

So, if you want to only prompt the user ONCE for all the reports, create a
form, and refer to it in the Criteria row of the query.

Guess I'm missing the problem here.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Sorry for not responding sooner.

There is only one query that feeds all 5 reports. Each report uses a
different piece of information.
and
One of the parameter prompts is in a query that the final query pulls from
(both prompts aren't in the same query).

Create an unbound form, with text boxes where the user can enter the
values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]

I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five
reports (two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add
the 5 reports to one, as 5 sub-reports, the Parameter prompts the user 5
times. Is there any way around this so the user is only prompted once?