Crosstab Query Error Message

[opkpapp11]

Here is error message i got:

The Microsoft Jet Database enine does not recognize 'Forms!frmUsers!txtStart' as a vaild field name or expression.

I have a select query feeding the crosstab that the WHERE is tied to the 'Forms!frmUsers!txtStart' on the form.

The select query opens up all good and filtered, I don't understand why when i try and feed the information to a crosstab query it gives me this error.

what gives?

 

[pbaldy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

Paul
MS Access MVP 2007/2008

 

[opkpapp11]

Bow

 

[pbaldy]

LOL, no bow required. I just try to save others from the bumps I have on my head from banging it against the wall. That one got me good way back when.

Paul
MS Access MVP 2007/2008