>i have a combobox with 3 columns, and i want that when i choice one line that return me the value of the 3rd >column, but that dosnt happend alway return the 1st one....what i forgot to do ?
>when i made it from the 'builder' that askme what column return and i select the 3rd one but still returning the 1st >one.....
>for your help , thanks in advance.
I'm not really sure what you're asking but...
Depends on how you want to use it but...
Try setting boundcolumn = 3
OR
I assume your rowsourcetype is either a SQL (3) or someother choice that references an alias or field(s) of a table. With all these situations, I think the best way to access the third column would be reference the column by name.
EXAMPLE: if your
rowsourcetype = 3 (SQL)
rowsource = "select column1, column2, column3 from mytable into cursor mylist".
To access the third column (column3) you would, in your interactivechange event,
do something like lcMyVariable = mylist.column3.
good luck.
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!