ComboBox with two columns

[Nenya]

Hi

I have a combo box with 2 columns, one for an index (code), one for a name. When a value is selected, only the index is displayed.

I'm trying to find a way to display the name in a text box (or anything else) so that the name is visible.

I've tried for days already! Please help if you can!!!

 

[Rich]

=[ComboName].[Column](1) as the control source for an unbound text box will display the second column

 

[Nenya]

Thx!!!

I can beleive i past so much time on this...