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 (zero) 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 Microsoft Visual Basic for Applications code containing an expression that refers to a form or report, the form or report must be open.