crosstab query does not recognize form reference

From: SusanW (anonymous_at_discussions.microsoft.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:39:24 -0800

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
data*** 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