G
Guest
I have two queries that filter information based on the same date range. So
I could avoid entering the same information twice, I built a form with a
calendar and now enter the date range once. From there, I built a report
based on one of the queries and a subreport based on the second query.
Here's my problem: When I use the form to update the queries and open my
report, the dates entered into the form work fine for my main report, but I
get "Enter Parameter Value" when it tries to pull the information for the
subreport. Both queries are based on the same table and both queries contain
the same expression "Between [Forms]![Choose Date]![StartDate] And
[Forms]![Choose Date]![EndDate]". I don't understand why the main report
would function well, but the subreport doesn't seem to see the data entered
through the form.
Any suggestions?
I could avoid entering the same information twice, I built a form with a
calendar and now enter the date range once. From there, I built a report
based on one of the queries and a subreport based on the second query.
Here's my problem: When I use the form to update the queries and open my
report, the dates entered into the form work fine for my main report, but I
get "Enter Parameter Value" when it tries to pull the information for the
subreport. Both queries are based on the same table and both queries contain
the same expression "Between [Forms]![Choose Date]![StartDate] And
[Forms]![Choose Date]![EndDate]". I don't understand why the main report
would function well, but the subreport doesn't seem to see the data entered
through the form.
Any suggestions?