Crosstab queries parameters 2

[MJD1]

I am trying to set a parameter into a crosstab query, using a Form Reference.
this works fine with a select type query,
but when I change it to a crosstab query, it give me error message.

"The Microsoft jet database engine does not recognize '[Forms]![monthly LPI stat form]![dm]' as a valid field name or expression.


anyone have a solution?

thanks

 

[dhookom]

You must declare your query parameter data types. Select Query|Parameters and enter
[Forms]![monthly LPI stat form]![dm] Text (or whatever)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MJD1]

thanks! it worked great.

martin

 

[JeremyNYC]

Man, I spent so many hours trying to figure this out before I learned the answer to that question. It was the weirdest thing, as I'm sure MJD1 could attest to. Cheer, Duane, for helping someone out of a hole that had me trapped for a long time, not so long ago.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.