Combo Box Values

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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)
 
Back
Top