Crosstab Queries

[Rob.Mills]

What is it with crosstab queries??

I have one based off another query. In the first one there is a criteria that references a combobox on a form. Running that query works fine on that criteria.

But when I run the crosstab off of it it says it doesn't recognize that parameter as a valid field name.

Anyone know how to get around this?

 

[GGib7711]

You need to declare the data type of the parameter in the first query.

Open the first query in Design View. Choose menu Query, Parameters...
Type the combobox reference in the Parameter column i.e.

[Forms]![formName]![comboBoxName]

In the next column, select the correct Data Type.

 

[Rob.Mills]

YES!!

Thank you. That did it.