Combo Box Values

G

Guest

I have a combo box on a form that uses multiple columns from a query as it's
recordsource. How can I acces the data in the columns other than the bound
column?
 
N

Nikos Yannacopoulos

Jim,

While Me.cboName returns the value of the bound column,
Me.cboName.Column(i) returns the value of column i (where the first
column is 0 and the last one is n-1, if n columns in total).

HTH,
Nikos
 
A

Allen Browne

Use the Column() property of the combo.

The first column is counted as zero, so the 2nd column of a combo named
Combo1 would be:
[Combo1].Column(1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get the value of non-bound combo box column? 5
Retain combo box order 1
incorrect null value in combobox 5
Combo Box Showing only bound column when choice is made -- the new normal? 1
Combo Box - Display other than column 1 6
ComboBox passing values from selected 2
combo box - bound column 2
Filter subform with combo box on main form 1

Top