[AccessD] Crosstab uses form criteria not

Bob Heygood bheygood at abestsystems.com
Tue Jun 15 14:55:37 CDT 2010


Hello to the list,

I have a query that uses a couple of references to controls on a form to
limit the date range for criteria.
It works just fine.

When I try to use the same query as a source for a second query (crosstab),
Access barfs and says:
"The Microsoft jet database engine does not recognize
'{Forms]![frmReports]![cboMonths]' as a valid field name or expression"

Does not the same jet engine work the same when creating a crosstab?

Thanks in advance,

Bob Heygood





More information about the AccessD mailing list