Microsoft KB Archive/103129

{|
 * width="100%"|

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