Q: ComboBox value

J

JIM.H.

Hello,

[Forms]![myForm]![MyComboBox] this gives me first value in a combined
combobox, how should I reach second column value?
Thanks,
 
B

Brendan Reynolds

Forms!myForm!myComboBox.Column(1)

The Column collection is zero-based, so Column(0) is the first column,
Column(1) the second, etc.
 
J

John Vinson

Hello,

[Forms]![myForm]![MyComboBox] this gives me first value in a combined
combobox, how should I reach second column value?
Thanks,
Click to expand...

Actually, it gives the Bound Column (which might be any column in the
combo).

To retrieve any column, use the combo's zero-based Column property.
The second column would be

[Forms]![myForm]![MyComboBox].Column(1)

John W. Vinson[MVP]
 
Top