ACC: Filtering Form with OpenForm Action Causes "#Name?" Error
Article ID: 102670
Article Last Modified on 5/6/2003
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q102670
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
A form that is opened with an OpenForm action that specifies a query
for the Filter Name argument, may display a "#Name?" error message for
some controls.
CAUSE
When a query is specified as the filter for the OpenForm action, the form
is bound to the fields in the query. If the form contains controls bound to
fields that are not included in the query, those controls display the
"#Name?" error message.
RESOLUTION
Switch to Design view and either change the query so that it contains
all the fields used in the form or clear the Restrict Available Fields
check box.
WORKAROUND
- Open the Filter Customers By Letter A query in Design view.
- On the View menu, click Properties. Set the Output All Fields property
to Yes (or clear the Restrict Available Fields check box in version
1.x).
- Choose OK and save the query. Note that the form now displays the
correct values for all controls.
STATUS
This behavior no longer occurs in Microsoft Access version 7.0.
REFERENCES
Microsoft Access "User's Guide," versions 1.0 and 1.1, pages 532-534, 558
Additional query words: poundname
Keywords: kbfix kbprb kbusage KB102670