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

ID: Q209485

The information in this article applies to:

Microsoft Access 2000

SYMPTOMS

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

This article applies to a Microsoft Access database (.mdb) and 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.

Additional query words: poundname prb


Keywords          : kbdta FmsCmbo 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999