Filter to Crosstab query

[CHTHOMAS]

I have a form and a report based on the same crosstab query. when i try to apply filter to the report as ([Forms]![form1]![EMPNUMBER]=[crosstabQuery]![EMP NUMBER]the following error comes &quot;Microsoft does not recognize [Forms]![form1]![EMP NUMBER] as a valid field name or expression&quot;. Any suggestions or ideas are welcome. Thanks in<br>
advance.<br>
Charley

 

[DougP]

1. Do you have a form named &quot;Form1&quot;<br>
2. is the a textbox on the form named EMPNUMBER<br>
Note both the &quot;name&quot; and the &quot;control source&quot; should match in the properties of the textbox on form1<br>
<br>
I suspect you added a textbox changed the control source but left the NAME in the name porperty to it's default like Text31<br>
<br>

 

[Praxden]

I'm having the same problem. It only seems to effect crosstab queries. Here's my code

TRANSFORM First(tblData.Data) AS FirstOfData
SELECT tblData.YmodData
FROM tblData
WHERE (((tblData.Diagram)=&quot;243132-01.dwg&quot)
GROUP BY tblData.YmodData
ORDER BY tblData.YmodData DESC , tblData.XmodData
PIVOT tblData.XmodData;

This code works as is. If I try to change it to filter thru a combo box I get the same error. I get a can't find object error when I try it in code.


Any suggestions


Praxden