Access 2000 query parameter problem

[mdo]

Hello,

I'm getting the following error when I'm trying to create a graph:


The Microsoft Jet database engine does not recognize '[forms]![frmname]![comboboxname]' as a valid field name or expression

When I run my select query it works fine.

I have used/done this before without any problem, but why am I having problem now?

Please help.

Thanks.

 

[pbaldy]

Is the form open when you try to run this (it needs to be)?

 

[mdo]

Yes my form is open. That's why my select query works fine.
Any idea?

 

[pbaldy]

Hmm. Is the graph based on the same query that works fine? If not, is it based on a crosstab query? A crosstab query needs to have its parameters explicitly declared, or it will return an error like that.

 

[mdo]

Hi Paul,

Yes, the graph is based on the same query that works fine.

 

[pbaldy]

I'm stumped then; can you post a sample db with the table, form, working query and graph in it? We'll sort this out yet.