Hi,

Ive come across a problem which I think might be due to the limitations of the chart function in access but I wonder if anybody could help.

I created a graph report based upon a query. The graph worked fine. But then I had a requirement to filter the data so I added a combo box to my form and updated the query to reference the data in the combo and filter by it ([forms]![frmReporting]![cmbGraph_Phase]. So, therefore, when I run the query it picks up the entry in the combo and filters the data to only include those records.

This all works fine. BUT, when I select to run the report (graph) it comes up with the standard message 'The Microsoft Jet Database Engine does not recognise [forms]![frmReporting]![cmbGraph_Phase] as a valid field name or expression'.

Ive tried a few things but cannot get past this problem. Does anybody have any ideas?

Would be very grateful for any solutions.

Thanks,
Adam.:confused:

You have to define the parameters in the graphs underlying query

Thanks for your reply.

I have already defined the parameters in the graphs underlying query as well as the main query. But to no avail Im afraid. Any other ideas?

Thanks,
Adam.

Post a 97ver here

I have attached an extract from the database with the problematic fields etc.

Either open the report up via the form, or directly open the report. You will encounter the problem before long.

Please...please...please if anybody can fix this I would be extremely grateful. Its driving me nuts!

thanks,
Adam.

Has anybody had chance to look at the database attachment yet? I have tried a few more things, but still cant get it to work. I have to assume this is a bug within Access.

As I said to you before you have to define the query parameters, I'm not sure you can use the Like operator though.

Adam,

I don't know if you have solved this one as yet but here is your database with the graph working.

Cheers

Flyer:D

Apologies - no attachment. Should be here this time

As I said to you before you have to define the query parameters, I'm not sure you can use the Like operator though.

Sorry to drag this old thread up, but I am having the same problem:

'The Microsoft Jet Database Engine does not recognise [forms]![frmReporting]![cmbGraph_Phase] as a valid field name or expression'.

I tried to download the repaired example, but it said I dont have permission to view.

I feel the answer is with Rich "You have to define the parameters in the graphs underlying query"

I am trying to set the chart to a specific date range but every time I try, the above message appears.

Rich, could you expand a little, pleeeeaaase

Dave