Enter date criteria only once for Report and subReport. (1 Viewer)

Zc kaiva

New member
Local time
Today, 12:51
Joined
May 9, 2021
Messages
9
For eg. Report1-main report
Subreports. SubReport1, SubReport2.
When i open my main report, it asks me to enter criteria( date) 3 times. Is there any way i can enter date criteria only once for all reports?
 

arnelgp

once i caught a fish alive...
Local time
Today, 19:51
Joined
May 7, 2009
Messages
13,236
use Tempvars as criteria.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:51
Joined
Feb 19, 2002
Messages
32,259
Add an unbound control to the form that runs the report. Put the criteria there. Change the RecordSource query of the report to reference the Form field:

Where SomeField = Forms!myform!SomeField
 

Users who are viewing this thread

Top Bottom