update text field with list box selection..

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to control what is displayed in a combo box 4
How to get one field to update based on a selection from a drop do 1
Multi-Select LIst Box Not Appearing in Text Box 2
text box format 11
How to save multiple selection from a list box in a bounded field 1
Selection from List Box to Text Box 5
Update Table based on Multiple List Box selections. 3
List box selection into combo box 2

Top