pass paramter to crosstab query report

[Souris]

I have a crosstab query with parameter which works when I open the query
while design my app.

I use the crosstab for my report. I assign the paramter using VBA code at
run time.

The report prompts the paramter at design time which does not prompt using
other query.

It does not have any fields to let me select when I use paramter crosstab
query.
It does work if my report uses crosstab without parameter.

Does report support crosstab query with parameter?
If it does, where I should look in to?
If not, are there any workaround for this?

Your help is great appreciated,

 

[KARL DEWEY]

Use a form to enter the parameters, declaring them in the crosstab. Open
query in design view, click on VIEW - Query, choose Parameters. Add the
parameter like --
[Forms]![YourFormName]![YourTextBox] and enter TEXT in Data Type. Save.

Enter parameter data in form text box and let the form stay open when you
run the report.