Combobox-retrieving data

  • Thread starter Thread starter Guest
  • Start date Start date
To display only the second column, on the combo box property sheet set the
column count to 2 and then in the column width box set the width of the
first column to zero.

--Wesley

Udi said:
i want to get the value of the second column of a combobox (the first
column is bound)
 
Udi,

If this is in the controlsource of an unbound textbox on the form...
=[NameOfCombobox].[Column](1)

If it's within a VBA procedure...
Me.NameOfCombobox.Column(1)

- Steve Schapel, Microsoft Access MVP
 
Back
Top