Microsoft KB Archive/103129
ACC: "#NAME?" Error Referring to Combo Box Column in Subform
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1, 2.0
- Microsoft Access for Windows 95, version 7.0
- Microsoft Access 97 for Windows
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:
However, if the combo box is on a subform, the text box returns the message:
To work around this behavior, you can refer to the column of the combo box that is on the subform through the main form, even though the text box is actually on the subform.
For a subform with a combo box and a text box, the following syntax returns the correct result:
NOTE: Columns are numbered starting with 0, not with 1.
Additional query words: poundname
Issue type : kbprb
Technology : kbAccessSearch
Last Reviewed: November 15, 2000