Report with sub-report and chart

[Darla]

I created a report...probably not the best way...it has a
sub report on one side that list a breakdown of
information for my chart and on the right side is a pie
chart. Each is based on it's own query. In each query I
have criteria in a field asking for Between[beginning
date] and [ending date]. This allows you to pick the dates
needed. When I open the report it ask for the dates for
the subreport and then again for the chart.

Is there a way I can enter the dates needed in one form
and have it select the information needed out of both
queries? Can I just reference the form field in both
queries? I'm sure my problem is just too much thinking.

Thanks for any help.

 

[Fons Ponsioen]

Hi.
The best way to accomplish this is to create a form with
two unbound text boxes containing the startdate and enddate
That you can refer the underlying queries to these boxes
using:
forms!ParamForm!startdate
etc.
Hope this helps.
Fons