Select vs. Crosstab Query

[Guest]

I have made a select query that refers to a control on a form i.e. [Forms]![Form Name]![Control Name]. This query works fine. When I make the exact same reference in a crosstab query I get an error message saying: The Microsoft Jet database engine does not recognize my reference as a valid name or expression. What is the difference between the two types of queries in recognizing names?

 

[Nikos Yannacopoulos]

Steve,

Unlike other query types, in a crosstab you are required to explicitly
declare parameters. To do so, open the query in design view and go to menu
item Query > Parameters, and define as a parameter the form control
reference you are using in your criterion (type in the exacct same reference
and choose the right type). This will solve your problem.

HTH,
Nikos

I have made a select query that refers to a control on a form i.e.

[Forms]![Form Name]![Control Name]. This query works fine. When I make the
exact same reference in a crosstab query I get an error message saying: The
Microsoft Jet database engine does not recognize my reference as a valid
name or expression. What is the difference between the two types of queries
in recognizing names?