Need to have textbox update from another text box

[Skip Bisconer]

I have a form based on a query of a table. The first textbox 1 is a general ledger expense description and textbox 2 is the actual general ledger account number. I changed the first text box to a combobox with a rowsource of a Chart of Accounts table (unrelated to the form query) with two columns GLExpense and GLCode.

I want the second textbox "GLCode" to pick up the second column of the rowsource for combobox "GLExpense".

Every thing I have tried so far doesn't make it happen. The combobox populates OK but I tried the below code on the GLExpense AfterUpdate code builder to populate the GLCode field but no go. I also tried an unbound combobox to lookup and find a record
me.GLCode.value = me.GLExpense.Column(1) to try to pick up the gl code number but it doesn't. Can someone point me in the right direction?

 

[boblarson]

Skip:

Did you make sure to change the Number of Columns property of the combo box to 2?

 

[Skip Bisconer]

Thanks Bob,

That did the trick.