how to retrieve combo box second column value

[Former Member]

I load the combo box data from query with code, description, qty and date.

When I select the combo box, how to retrieve the combobox value from 2nd, 3rd columns and display into Textbox?? 

[Former Member]

hi.

As i understood is.

u need load some values from query like

column1  column2

one         qty

two         qty1

three      qty2

little bit confusion

u can not load  3 columns in comobo box..

only 1 and 2

when ever u select the combo box only first column value will save i think....

u can capture

dim string_1 as sring=ocomobo,selected.value

i think above one u know.

but u asked 2nd and 3rd column

i think it is not possible..

if u say any possibilities

again search in data base based on the selected value

dim Select_value as sting = ocombo.selected.value

now Recordset object..

search in sql

select   two,three from table where  column1='Select_value'

Do your operation.

========

you can achieve above task  by using Cfl...if it is type of object.

if above one is wrong just wait for expert suggestions.

[Former Member]

I don't mean to save.. just want to retrieve..

[pedro_magueija]

Hi Eric,

The selected property of the combobox has the ValidValue containing both Description and Value.

myCombo.Selected.Value;

myCombo.Selected.Description;

---

Best regards,

Pedro Magueija