Passing Query Criteria to subreports (1 Viewer)

tsmithjr

Registered User.
Local time
Today, 12:42
Joined
Apr 25, 2017
Messages
12
I have a main report that is basically acting as a template. It contains no data itself but uses the Main query as the Record Source and Prompts the user with a Start and End Date request. Within the Main report are 4 Sub reports that are all using different queries built off the main query and other queries to gather data and complete the request. Everything is working fine with the data and reports except I have to enter the Start Date and End Date 5 times...once for each report.

I set the Link Master & Link Child Fields to the [Trans Date] field on all reports which is the field I'm entering criteria on hoping that would pass through the Date Criteria entered but that didn't work.

Any help would be greatly appreciated.

Thank you
Tom
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 09:42
Joined
Aug 30, 2003
Messages
36,118
Most of us would use a form to gather user input. You have more control, and they only enter the values once.
 

tsmithjr

Registered User.
Local time
Today, 12:42
Joined
Apr 25, 2017
Messages
12
Wasn't sure how to do this but it was very simple. Thanks for pointing me in that direction! :)
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 09:42
Joined
Aug 30, 2003
Messages
36,118
No problem! I think you'll be happier in the long run.
 

Users who are viewing this thread

Top Bottom