Look-up Column in Text box access form

Hi all,

i have 1 combo box and 1 text box i look up 2 columns in the combo box from that combo box i want to look up 2 column to text box



example:

Table values:

Col 1 Col 2

A 1

A 2



combo box successfully look up 2 columns but i look up to text box

Formula: =combo1.column(1)



but the text box look up the first row always even i choose the second row A

also look-up first row 1

any solution to look up 2nd row?

Look-up Column in Text box access form