Parameter Query with Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report based on a parameter query, getting options from a
combo box (so users don't have to type in very long options, but I'm getting
a help message saying: "The expression you entered has a function name that
Microsoft Access can't find."

What am I doing wrong and how can I fix this?

Thanks

ps. Sorry if I've posted this twice. I had a problem with my windows
 
Muzzmonster,

The source of this problem could be one of a number of possibilities.
When do you get the error message... when you try to print the report?
It could refer to an expression in the query that the report is based
on, or in some code in the report's module, or in the control source of
a control on the report, or in the report's sorting & grouping setup, or...

Maybe the first thing to try would be to open the query's datasheet (go
to the design of the query, and then click the toolbar button with the
red [!] icon), and see if that returns the expected data. If so, the
problem is probably somewhere on the report itself. But if it doesn't,
select SQL from the View menu, and then copy/paste the query's SQL view
into your reply.
 
Please post your SQL for the query and a couple of examples from the combobox.
To post the SQL open the query in design view and click on menu VIEW - SQL
View. Copy and paste in post.
 
Back
Top