passing parameters to a cross tab query from a control on a form.

[Sasha]

I have a report based on a cross tab query. I have a form which open sand
allows the user to input a parameter for the report via a text box on the
form. The issue....how do I pass into the cross tab query a parameter from a
control on the form?

Thanks.
Sasha

 

[Duane Hookom]

You can use parameter like any other query except that you must explicitly
describe the parameter data types. In design view, select Query|Parameters
and then enter your exact parameter(s) and data type(s).