Using Combo Box Column( ) Property in SQL Code (1 Viewer)

[dungstar]

In a multi-column ComboBox, how do I call other columns (not the first one) in SQL.
This code works for calling the information from the first column:
[Forms]![frmLocation]![cboLocation]

I want to use a retrieve a value that is in the third column, so I try this:
[Forms]![frmLocation]![cboLocation].Column(2)

This code doesn't work in SQL, what's the proper to retrieve a value from another column?

 

[SimonC]

Try this:

[Forms]![frmLocation]![cboLocation].[Column]![2]

Simon.