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

  • Thread starter Thread starter Sasha
  • Start date Start date
S

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
 
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).
 
Back
Top