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

Zc kaiva

New member
Local time
Today, 07:50
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

..forever waiting... waiting for jellybean!
Local time
Today, 15:50
Joined
May 7, 2009
Messages
19,169
use Tempvars as criteria.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 03:50
Joined
Feb 19, 2002
Messages
42,981
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