transfer a ComboBox column value to a textbox after update

[Andre Beier]

Hi,

I have a ComboBox with 4 columns. The data comes from a recordset.
When the user changes the selected item of the Combobox, I want to put the
value
of the last column into a regular Text Box.

When I use
-------------------------------------------------
Me.TextBox.Value = Me.ComboBox.Value
-------------------------------------------------
I get the unique ID of the record.


I also tried
-------------------------------------------------
Me.TextBox.Value = Me.ComboBox.Itemdata(3)
-------------------------------------------------
but it did not work.

Thanks in advance

Andre

 

[Peter Hoyle]

Try

Me.TextBox= Me.ComboBox.Column(3)

The index is zero based so Column(3) actually gets the 4th column,

Cheers,
Peter

 

[Andre Beier]

Thanks,

that was exactly what I was looking for.