Article ID: 209218 - View products that this article applies to.
This article was previously published under Q209218
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you print or preview a report, you may receive the following 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.
Unless a crosstab query uses fixed column headings, you cannot preview or print a main report with a bound subreport that is based on a crosstab query.
To work around this behavior, add fixed column headings to the crosstab query's properties. For example, the following steps show how to fix the problem created in the "Steps to Reproduce Behavior" section of this article:
Steps to Reproduce Behavior
For more information about the ColumnHeadings property, click Microsoft Access Help on the Help menu, type ColumnHeadings property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Contact us for more help
Connect with Answer Desk for expert help.