Passing variable to sub-report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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

John W. Vinson [MVP]
 
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!!!
 
Back
Top