Pass-through query for sub report

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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,
Click to expand...

Yup!

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

Rdub
 
Back
Top