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

ID: Q103129

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

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          : FmsCmbo 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: March 25, 1999