Using Access 2002.
I have a chart in a report that is currently based on a query in which
the user enters the start and end date for the chart to display. Both
the start and end dates have been identified as parameters so that the
date range can be found without causing an error. So far so good,
report works as it should.
Here's the problem. There are several reports that need to be printed
at the end of month that use the same date ranges. Is there any way
to have the query pick up its start and end dates from a form instead
of entering it for each report? I have tried experimenting with this,
but have a problem with the parameter values. If I completely remove
the parameter values, I get the typical OLE error. If I attempt to
modify the parameters to match the Forms!.... information, I get a
bracketing error. Has anyone been able to get through this and if so,
what did you do?
Thanks for any help you can provide,
Mike.