Graphs from query.

R

Rubianob

Hi,
I have a weird problem:

I have a graph in a form that gets the data from a query. The graph change
according to the user selection in the form using a Combo Box(Rec_GrCarr is
the name of the ComboBox). I am using the expression
Forms![F_GraphCarrier]![Rec_GrCarr] as the criteria in the query.

When I open the form I got the message:

"The Microsoft Jet database engine does not recognize
'Forms![F_GraphCarrier]![Rec_GrCarr]' as a valid field name or expression."

Next I got another message"

"An Error occured while sending data to OLE server..."

The weird thing is that when I open the form using a constant value in the
criteria field in the query, it works without problem.

In summary, I got the problem when I use a variable as the criteria in the
query.

Any help on this would be very appreciated.
 
Top