Question about filters in a report

J

Joe Cilinceon

I have a Summary report that has several subreports. Most of these are based
on a data span such as the first to the current day of the month. Now I have
coded each subreport on the filter like with things like

[DepDate] Between Reports![rptSummary]!StartDate And
Reports![rptSummary]!EndDate
or
[PaymentDate] Between Reports![rptSummary]!StartDate And
Reports![rptSummary]!EndDate

Is there a way to have these set in code so they don't get erased every time
I modify something in the report. Every time I open one of the subreport to
modify it a bit I lose the filter and have to paste it back. I hope this is
clear.
 
Top