Chart in my report won't use the underlying query

[pmo]

My report consists of 1 chart. The report its self is not bound to a table or query. The chart however uses information from a query.
If I filter the query by putting a filter in the grid as normal everything works fine.
If I add an [Enter Name] to the grid or a reference to a form [Forms]![ReportF]![Combo65]to the grid I am prompted with "The jet database engine does not recognise [Enter Name]as a valid field name or expression. It then continues to the report without displaying the graph.
If I run the query on its own all works with no problem and I am prompted with [Enter Name.
Can anyone help?

Wayne

 

[GingerR]

in the query design, right-click in the grey part up top and view PARAMETERS. put in each of your parameters and their data type:


[Forms]![ReportF]![Combo65] Text
[Enter Name] Text

see if that works.

g

 

[pmo]

GingerR,
It works. Thanks for your help.
This has caused me some considerable stress.
Thanks Again

Wayne

 

[GingerR]

no problem. i went thru the same thing. dont even know how i figured out how to fix it, but it's been a life saver for me to for a long time.

have fun!