Look-up Column in Text box access form

[anbusds]

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?

 

[stopher]

This is probably because both of your values in col 1 are "A". So when your formula looks up the corresponding value for A in the record source, it will take the first value i.e. 1.

You can test the theory by changing the second A to B.

If the A's a are necessary, then just add another column at the beginning with unique values to act as the key.It can be hidden.

What is the purpose of A 1, A 2 anyway? Perhaps there is a better way..

Chris

 

[anbusds]

Hi Chris,
Yes am doing the same way that you are explained above, just want to know that is possible or not?
i think access have some limitation on that...
Thanks for your reply...


Anbu

 

[RainLover]

You could try using the wizard to build the Combo for you.

This may help.

Column 1 is the second Column. Column 0 is the first.