update text field with list box selection..

N

nycdon

a2003...trying to update a text box bound as.. = [firstname] & " " & +
[Lastname}, to the column values of List box selection with following code..

Me.txtname = Me.ListName.Column(2) & Me.ListName.Column(1)

Says I can't update with runtime 2135 error. Also tried setting
controlsource as above..

any comments welcome
thanks!
 
G

G. Vaught

I believe the Me.ListName.Column(2) only works with Combo Boxes. You are
concatenating the textbox to one value using the & " " &, therefore there is
no two columns.
 
Top