ACC2000: "#NAME?" Error Referring to Combo Box Column in Subform (209485)

The information in this article applies to:

Microsoft Access 2000

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:

#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.

Modification Type:	Major	Last Reviewed:	6/28/2004
Keywords:	kbprb KB209485