Report criteria requested 4 times

[Pete]

Using Access 2007. I have a Report which has no control source but has 4
SubReports which neatly summarise information required. Only problem is that
parameters of person “initialsâ€, and “dates between" are asked for 4 times.
Currently no ‘mother’ and ‘child’ relationship between SubReports or with
Main Report (which is blank). Parameter criteria are given in exactly the
same format in each of the 4 queries upon which the Reports are based. The 4
Reports work perfectly on their own, and also in the Summary group. Can
someone tell me in a simple way how to make it that I am only asked the
parameters once. I would be very appreciative. Thanks.

 

[KARL DEWEY]

If the information was placed in an open form text box which remains open
then it would not request ever as it would have it.

 

[Pete]

I have created the open form text box as suggested but am missing something
fundamental about how this operates. Many combinations of using / not using
the criteria in the SubReports still end up with either getting unfiltered
data or again being asked 4 times for the criteria. Could you possibly spell
things out in finer detail? Thanks.

 

[Duane Hookom]

Each query in the reports' record sources would replace your parameter
prompts with something like:
Forms!frmYourFormName!ctlYourControlName

 

[KARL DEWEY]

Use the form text box as criteria in the queries that feed the reports --
[Forms]![YourFormName]![TextBoxName]

 

[Pete]

Many thanks. After hours of working it all out it has been achieved.

Use the form text box as criteria in the queries that feed the reports --
[Forms]![YourFormName]![TextBoxName]

--
Build a little, test a little.

I have created the open form text box as suggested but am missing something
fundamental about how this operates. Many combinations of using / not using
the criteria in the SubReports still end up with either getting unfiltered
data or again being asked 4 times for the criteria. Could you possibly spell
things out in finer detail? Thanks.