Using crosstab query as a record source for a subreport? 1

[sjh]

Hi,
When I tried to add a subreport which uses a crosstab query as a record source to another report, I got this error message:

You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport.

Before you bind the subform or subreport to a crosstab query, set the query's ColumnHeadings property.

Is there a way to fix this situation? Please advise!

Thank you,
SJH

 

[dhookom]

Sure, you can fix it by setting the Column Headings property of the crosstab query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sjh]

Thank you!

The ColumnHeadings property is a good thing to know.

SJH