Microsoft KB Archive/111780

Knowledge Base

ACC: Cannot Use SQL Pass-Through Command for Subreport

Article ID: 111780

Article Last Modified on 1/18/2007

---

APPLIES TO

• Microsoft Access 1.0 Standard Edition
• Microsoft Access 1.1 Standard Edition
• Microsoft Access 2.0 Standard Edition
• Microsoft Access 95 Standard Edition
• Microsoft Access 97 Standard Edition

---

This article was previously published under Q111780

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you try to use a SQL-specific pass-through query as the RecordSource property setting for a subform or a subreport, you may receive the following error message:

Can't use a subform or subreport bound to a crosstab query in which the column headings can vary

CAUSE

Reports require a list of fields to create a subreport, and a list of fields is not stored in a SQL pass-through query.

STATUS

This behavior is by design.

REFERENCES

For more information about SQL pass-through queries, search the Help Index for "pass-through queries, creating."

Additional query words: can t use a subform or subreport bound to a crosstab query

Keywords: kbprb kbusage KB111780

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.