Article ID: 103131
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 Q103131
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you print a form or report that contains a subform/subreport that
calls an ApplyFilter macro action in its OnOpen event, you receive the
following error message:
The action or method is invalid because the form or report isn't bound
to a table or query.
Even if you do not receive this error message, you see that the ApplyFilter
action has not been executed.
CAUSE
When printing, Microsoft Access erroneously tries to apply the filter that
is run from the macro to the outermost (main) report/form, rather than to
the subreport/subform.
The error occurs because the main report/form does not contain a
RecordSource property setting to perform the ApplyFilter action against.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 1.0, 1.1,
2.0, 7.0, and 97.
Additional query words: subreports reports subforms the action or method is invalid because the form or report isn t bound to a table or query
Keywords: kbbug kberrmsg kbusage KB103131