Crosstab query not recognising textbox input ref

[robbydogg]

Hello all,
I have a bit of a problem with my CT query.
The normal query seeks it's reference from the code "[Forms]![Frm_main]![referencetextbox]" referencetextbox is a textbox on the main form of the screen and i want the CT query to look at this to then show detail. The normal query works fine, but the CT shows Jet engine Database does not recognise [Forms]![Frm_main]![referencetextbox] as a valid reference.

I find this strange because the normal query has exactly the same detail, just not cros-tabbed.

can anyone help?


thanks.

 

[DCrake]

Do you have the form open when you run the first query?
Is the first query the underlying query for the corsstab query?
Do you have the form open when you run the crosstab query?

If Yes, Yes, No then that's the source of your error. Even thought cosstab does not relate directly to the form the underlying query does.

There is a sample document (which I have attached to offer a solution to your problem)

CodeMaster:

 

[robbydogg]

hello,

thanks for your reply.

[Frm_main] is open when i run the CT query. the other query was just to check that the function should work, so the only one running is the CT query.