CHART Reports

  • Thread starter Thread starter Graham Whiteman
  • Start date Start date
G

Graham Whiteman

I am having problem passing query params to a report that
has a chart control on it. I am trying to pass
[forms]![MainMenu]![txtStartDate] to the chart such that
the Date field criteria is ">=[forms]![MainMenu]!
[txtStartDate]"

The error message I am receiving is:
The Microsoft Jet database engine does not
recognise '[forms]![MainMenu]![txtStartDate]' as a valid
field name or expression.

Followed by:
An Error occured while senidng data to the OLE server (
the application used to create the object).
* Blah blah

Is there another way I should be passing the params to the
report? I do not have any data source defined for the
parent report.
 
Hi - I clicked on the link but couldn't find the answer to the question you
posed. It just took me to a default location. I want a chart in a report to
display based on query input. When the user enters [start date] and [end
date], I want a chart based on that interval to display. Instead, I get an
error message similar to what you typed. Would really appreciate finding the
answer because it's driving me crazy. Thanks!
 
Back
Top