Query Expression Error

K

Karin

I created a form with a combo box to select query parameters. I run the form
from a report. Everything works, but prior to showing the data I receive an
error message: "The expression you entered has a function name tha Microsoft
Access can't find."

But it runs the query and the report with the parameter I selected. I can't
figure out where the error is.

Has anyone seen this before? (Getting to this point was not easy!)
 
J

John Vinson

I created a form with a combo box to select query parameters. I run the form
from a report. Everything works, but prior to showing the data I receive an
error message: "The expression you entered has a function name tha Microsoft
Access can't find."

But it runs the query and the report with the parameter I selected. I can't
figure out where the error is.

Has anyone seen this before? (Getting to this point was not easy!)
Click to expand...

Yes, I've seen this before - when I had a query with a function name
that Access can't find.

Evidently there is an error in your Query or in your code. Care to
post the SQL of the query so that someone might have a chance at
finding it?

John W. Vinson[MVP]
 
Top