Microsoft KB Archive/209485

= ACC2000: "#NAME?" Error Referring to Combo Box Column in Subform =

Article ID: 209485

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209485



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



SYMPTOMS
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

You can refer to a particular column of a combo box in a text box on a form by using the Column property as follows:   =Forms![Formname]![ControlName].Column(x). However, if the combo box is on a subform, the text box returns the following:


 * 1) Name?



RESOLUTION
To work around this behavior, use the entire path through the main form to refer to the column of the combo box on the subform.

For a subform with a combo box and a text box, the following syntax returns the correct result:   =Forms![MainForm]![Subform].Form![Controlname].Column(x) NOTE: Columns are numbered starting with 0, not with 1.

Additional query words: poundname prb

Keywords: kbprb KB209485

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.