populate text field based on list box selection

[Stew]

I have a list box (lstname) based on a Table. The list box is bound by column one (ID) and has a second column (manager) containing a name. I want to double-click the appropriate row and have the name appear in a text field on my form. I've tried Me.txtMytext.Value = lstname.ItemSelected and other variations but can't seem to get it to work. Any suggestions?

 

[Neal]

I had to do that just today. You can put this as the Control Source of the text box:

=[lstname].Column(1)

Column(0) contains the ID, Column(1) contains the name.

 

[Stew]

Thanks Neal