Re: crosstab query does not recognize form reference

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 12:33:14 -0600

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

-- 
Duane Hookom
MS Access MVP
"SusanW" <anonymous@discussions.microsoft.com> wrote in message
news:1398601c41747$1b5ea1c0$a601280a@phx.gbl...
> 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
Quantcast