Crosstab query reference to form

[Thomas]

I have constructed a drop down menu on a form. I reference the form in the
criteria of the query to the results of the updated drop down menu. I am
attempting to reference these same results of this update to a crosstab
query. However, when I call the field of the form to reference I get an
error: The Microsoft Jet database engine does not recognize [form
name/field] as a valid field name of expression. I have tried several
different workarounds, including querying the crosstab query and calling it
there - that also returns the same error. Any assistance anyone could offer
would be greatly appreciated!!! Thanks!

 

[Joan Wild]

Although it isn't necessary to declare the parameters in most queries,
crosstab queries are the exception.

Open the crosstab in design view and go to Query, Parameters. Put the exact
criteria you have (reference to the form control) as the parameter, and set
the correct datatype.

 

[KARL DEWEY]

Your parameters need to be declared for a crosstab query. Open the query in
design view and click on menu QUERY - Parameters. This opens a popup window
for parameters.
Enter the exact name and datatype --
[Forms]![YourFormName]![YourTextBox] Text 255