Combo Box column 2 retrieval

[JohnG]

Hi

I have a combo box with two fields, The first displays the product name
while the second column contains its related prices. I want my users to be
able to select a product using the drop down box and the product price(column
2) to be inseted into and unboud text box.

I've tried to use the Column propety of the combo box to retrieve column 2
data i.e

Me.Textbox1 = ComboBox1.column(2)

but this code return nothing

can anyone help
thanks johnG

 

[fredg]

Hi

I have a combo box with two fields, The first displays the product name
while the second column contains its related prices. I want my users to be
able to select a product using the drop down box and the product price(column
2) to be inseted into and unboud text box.

I've tried to use the Column propety of the combo box to retrieve column 2
data i.e

Me.Textbox1 = ComboBox1.column(2)

but this code return nothing

can anyone help
thanks johnG

Combo box column numbers are zero based, so the second column is
Column(1).

 

[Graham Mandeno]

Hi John

The enumeration of combo box (and listbox) columns starts at 0, so the
second column is:
ComboBox1.column(1)