Microsoft KB Archive/103129: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 1: | Line 1: | ||
{| | {| | ||
|width="100%"| | |width="100%"| | ||
== ACC: | == ACC: "#NAME?" Error Referring to Combo Box Column in Subform == | ||
|} | |} | ||
Latest revision as of 09:34, 20 July 2020
ACC: "#NAME?" Error Referring to Combo Box Column in Subform |
Q103129
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
SYMPTOMS
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 message:
#Name?
RESOLUTION
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:
=Forms![MainForm]![Subform].Form![Controlname].Column(x)
NOTE: Columns are numbered starting with 0, not with 1.
Additional query words: poundname
Keywords :
Issue type : kbprb
Technology : kbAccessSearch
Last Reviewed: November 15, 2000 |