Refer to a column in a list in an expression

You can refer to a column in a multiple-column list box or combo box by using the Column property of the list box or combo box control.

• Type the identifier for the Column property, followed by the index number of the column in parentheses. Use 0 to refer to the first column, 1 to refer to the second column, and so on. For example, the following identifier refers to the second column of the Country list box control on the Customers form:

  [Forms]![Customers]![Country].Column(1)

Note   When you run a macro or Visual Basic for Applications code containing an expression that refers to a form or report, the form or report must be open.

For more information on creating a multiple-column list box or combo box, click .

For information on referring to the value of a control or property in an expression, click .