Crosstab based on a query with parameters fed from a form?

[Guest]

I have a series of Crosstab queries based on one large query, with a month
field that changes frequently. I want the user to be able to enter the month
in a form, and then run the crosstab. The back-end query works great, but
the crosstab fails because the Jet database engine does not recognize
Forms![ProjectChargesInput]![Month] as a valid expression or field name.
Does anyone know of a way to fix that or work around it to achieve what I
want?

The reason this is so complex is that the users should not have the security
to see the query design to make changes there.

 

[Duane Hookom]

You must enter the data type of parameters used in crosstab queries. Select
Query->Parameters and enter

Forms![ProjectChargesInput]![Month] Integer

 

[Guest]

So simple...! Thank you so much!

You must enter the data type of parameters used in crosstab queries. Select
Query->Parameters and enter

Forms![ProjectChargesInput]![Month] Integer

--
Duane Hookom
MS Access MVP

I have a series of Crosstab queries based on one large query, with a month
field that changes frequently. I want the user to be able to enter the
month
in a form, and then run the crosstab. The back-end query works great, but
the crosstab fails because the Jet database engine does not recognize
Forms![ProjectChargesInput]![Month] as a valid expression or field name.
Does anyone know of a way to fix that or work around it to achieve what I
want?

The reason this is so complex is that the users should not have the
security
to see the query design to make changes there.