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

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: However, if the combo box is on a subform, the text box returns the following:

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: NOTE: Columns are numbered starting with 0, not with 1.