read the value in a combo box

G

Gus Chuch

I think this is a good question?
How would you read the value in a combo box?
A text box is simple enough Y = Me.txtBox1.Value
But a combo box with a column count set to 2 or higher.
Y = Me.cboBox1.Value will only give you the value in the first column, how
would you read the 2nd or 3rd.
 
F

fredg

I think this is a good question?
How would you read the value in a combo box?
A text box is simple enough Y = Me.txtBox1.Value
But a combo box with a column count set to 2 or higher.
Y = Me.cboBox1.Value will only give you the value in the first column, how
would you read the 2nd or 3rd.
Regarding:
Y = Me.cboBox1.Value will only give you the value in the first column,<
Click to expand...

cboBox1.Value will give you the value of whatever column is the bound
column, which may or may not be the first column.

To read the 2nd column:
Y = Me![cboBox1].Column(1)

To read the 3rd column:
Y = Me![cboBox1].Column(2)

Combo boxes are 0 based, so column(1) is the 2nd column, column(2) is
the 3rd,
 
Top