Access 2000 query parameter problem (1 Viewer)

M

mdo

Registered User.

Local time

Yesterday, 21:39

Joined

Aug 17, 2003

Messages

13

• Oct 25, 2003

• #1

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

Wino Moderator

Staff member

Local time

Yesterday, 19:39

Joined

Aug 30, 2003

Messages

36,123

• Oct 25, 2003

• #2

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

 

M

mdo

Registered User.

Local time

Yesterday, 21:39

Joined

Aug 17, 2003

Messages

13

• Oct 25, 2003

• #3

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

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:39

Joined

Aug 30, 2003

Messages

36,123

• Oct 25, 2003

• #4

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.

 

M

mdo

Registered User.

Local time

Yesterday, 21:39

Joined

Aug 17, 2003

Messages

13

• Oct 25, 2003

• #5

Hi Paul,

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

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:39

Joined

Aug 30, 2003

Messages

36,123

• Oct 25, 2003

• #6

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.