Microsoft KB Archive/111780

= 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.

