ACC: Cannot Use SQL Pass-Through Command for Subreport (111780)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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."
| Modification Type: | Major | Last Reviewed: | 5/6/2003 |
|---|
| Keywords: | kbprb kbusage KB111780 |
|---|
|