Microsoft KB Archive/103129

From BetaArchive Wiki

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


Last Reviewed: November 15, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.