Code in combobox, code in text box

[float]

Hello everyone,



I've been searching the past few hours on the internet for the following problem, but haven't been able to find an adequat solution for it

The problem:
I have a table with codes and the full text for the responding code. For example: 1000 is test1

I've made a form were the user can select/type the code but I'm not able to 'convert' the code in to text in the text box next to the combobox. To be clear: I don't want the text in the combobox :-)

Thank you for helping me out a bit!

[RuralGuy]

There are a half dozen solutions to this. Have you tried a DLookup() in the AfterUpdate event of the TextBox?

[float]

=[comboboxname].[column](2) did the trick, my problem is solved

[RuralGuy]

Excellent! Don't forget to mark this thread as Solved.