crosstab query does not recognize form reference

[SusanW]

I created a form where the users can choose the a
manufacturing plant. Then I created a query that shows
data only for that plant - the data is spread out in 4
different tables so that is the reason for a middle
query. This query only allows records where the Plant
Number equals the Plant Number from the form. I put that
in the criteria. I do not have the Plant number on the
query since it is a totals query and we just want the
product, action and count. All of this works fine. Now I
have to make a crosstab query with the product as the
row, action as the columns and the count as the data. It
creates it fine, but when I try to view the query in
datasheet form I get a message "The Microsoft Jet
database engine does not recognize '[Forms]![MyForm]!
[PlantNbr]' as a valid field name or expression". It
recognized it fine in the query that the crosstab query
is based on. Please help!

Sue

 

[Duane Hookom]

Open your first query with the criteria and select Query|Parameters and
enter
[Forms]![MyForm]![PlantNbr] Numeric or Text or whatever

 

[Dan]

I have the same problem and I followed your instructions
and I don't get the proper results. My query just ignores
the Parameters. Even if I type in the Parameter it is
ignored.

Dan

 

[Guest]

Forget I found my error.

 

[Duane Hookom]

Do you have the Forms!.... in the criteria also? The parameters augment the
information in the criteria, they don't replace them.