How do I display listbox column data in a textbox that is not the bound column?

[xwnoob]

hi,


I have a textbox that has a control source of my listbox. My listbox has two columns: Lender Id and Lender name and my bound column is 1. The control source is LENDERIDFK and its datatype is number so if i set the bound column to 2 it will give an error.So now do i display the lendername in the textbox without changing the bound column?

[orange]

Columns are numbered from 0.

Your textbox's control source
=
[List0].[column](1) ...whatever your listbox name is

In your Listbox's afterupdate event

Private Sub List0_AfterUpdate()
Me.Text2.Requery ...........................whatever the textbox name is
End Sub