ACC: Cannot Use SQL Pass-Through Command for Subreport

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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

Keywords : kbusage RptOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb