crosstab query does not recognize form reference

  • Thread starter Thread starter SusanW
  • Start date Start date
S

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
 
Open your first query with the criteria and select Query|Parameters and
enter
[Forms]![MyForm]![PlantNbr] Numeric or Text or whatever
 
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
 
Do you have the Forms!.... in the criteria also? The parameters augment the
information in the criteria, they don't replace them.
 
Back
Top