Report criteria requested 4 times

  • Thread starter Thread starter Pete
  • Start date Start date
P

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.
 
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.
 
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.
 
Each query in the reports' record sources would replace your parameter
prompts with something like:
Forms!frmYourFormName!ctlYourControlName
 
Use the form text box as criteria in the queries that feed the reports --
[Forms]![YourFormName]![TextBoxName]
 
Many thanks. After hours of working it all out it has been achieved.

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

--
Build a little, test a little.


Pete said:
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.
Click to expand...
Click to expand...
 
Back
Top