Pass-through query for sub report

[iccsi]

I use Pass-Through query for my sub report and get error message like
following:

"You can't use a pass-through query or a non-fixed-crosstab query as a
record source for a sub form or sub report"

"before you bind subform or subreport to a cross query, set a
cloumnheading property"

I had the issue with Crosstab query to set column heading to resolve
the issue.

Are there any workaround for this for pass-through query?
Your help is great appreciated,

 

[Ron Weiner]

iccsi formulated the question :

I use Pass-Through query for my sub report and get error message like
following:

"You can't use a pass-through query or a non-fixed-crosstab query as a
record source for a sub form or sub report"

"before you bind subform or subreport to a cross query, set a
cloumnheading property"

I had the issue with Crosstab query to set column heading to resolve
the issue.

Are there any workaround for this for pass-through query?
Your help is great appreciated,

Yup!

Create an Access Query that uses the Passthru as the From clause. Some
thing like: Select * From YourPassThruQry will likely do.

Rdub