Fill 2 diff txt boxes from value of 1st 1

[luismagally]

Hi,

I've got a small problem and don't know how to solve this yet. I've got a combo box reading values from a query. The query reads 2 columns into it:

COL_1 COL_2
val1 val2
val3 val4
.
.
.
valx valy

Besides the combo box is a text box on which I want to fill with the next column. If I choose in the combo box the value val1, I would like the val2 to appear in the text box.

Any ideas...

Thanks

 

[M8KWR]

if its any help to get the value of the second column in a combo box you would have to type

TEXT_BOX = COMBO_NAME.Column(1)

i.e 0 = Column1, 1 = Column2 and so on


I hope this help

 

[luismagally]

Thanks a lot, so easy and yet so far away from my grasp.

Thanks...