Crosstab Query link to Form

[Don]

i have a crosstab query and i want this query to show the data what i have
selected in the form,it is possible or is there any way to do this? 'coz i
cant run the query when i put in the criteria "[Form]![Main]![Select]" in
one of the field, its showing Microsoft jet engine does not recognize the
form as a valid field name or expression. please help. thanks in advance!

 

[John Spencer (MVP)]

With a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2