Passing variable to sub-report

[HeatherD25]

Hi,

I have a form where the user selects a beginning and end date, and then they
pull up a report that filters the data based on the dates they select. I
also have a sub-report on this report that I need filtered with the dates.
How do I get this to work?

Thanks!
Heather

 

[John W. Vinson]

Hi,

I have a form where the user selects a beginning and end date, and then they
pull up a report that filters the data based on the dates they select. I
also have a sub-report on this report that I need filtered with the dates.
How do I get this to work?

Thanks!
Heather

Base the Subreport on a query referencing the form, would be the simplest way.

John W. Vinson [MVP]

 

[HeatherD25]

I have the sub-report using the same query as the main report. Is that what
you mean?

 

[HeatherD25]

Thanks -- that fixed it. I just between a between statement in the critieria
for the query on the variable I wanted to limit referencing the form.
Thanks!!!