Crosstab Query Error

A

Alex Brown

I am using a form field to provide input to a report as it
launches. Everything works fine with normal queries but
as soon as I use a crosstab query I get the following
error message:

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

I am using a base query - which is where the criteria
expression appears - followed by a crosstab query layered
on top that provides the data for the report.

Please help!

Thanks,
Alex
 
Top