Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Pass-through query for sub report

655 views
Skip to first unread message

iccsi

unread,
May 31, 2011, 5:08:38 PM5/31/11
to
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

unread,
May 31, 2011, 8:12:49 PM5/31/11
to
iccsi formulated the question :

Yup!

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

Rdub


0 new messages