Combo Box column 2 retrieval

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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

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