Listbox quicky

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys
Just a quick one
Have a list box with 6 fields of data, would like to populate 2 text boxes
on my main form, the form cannot be related to the list box.
Have successfully populated one text box on selecting a record in the list
box from one of the fields, but am unable to find a way to populate the
second from another of the fields.
Is this possible?
Cheers Ross
 
one of the properties of a listbox is the columns collection.
me.txtBox1=lbx.columns(0).value
me.txtBox2=lbx.columns(1).value
.....
 
You must log in or register to reply here.

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

Refresh a listbox 1
Displaying query result on the same form as selection fields 6
Combobox in subform depending on combo in main form 5
How do I add items to a multi-select listbox on the fly? 2
Field types 4
Memo field truncated from form to table 4
Mult-Value Select returning ID# not text. 4
Overwhelmed, Just Started, Quick Question 3

Back
Top