retrieve multiple values from a listbox?

M

Michael House

I have a listbox based on a query.
I am able to retrieve the value of the selected item and
place it into a textbox.

By changing the BoundColumn, I can retrieve data from
different columns, however I am trying to retrieve 2
values.

What I'd like to do 'on click' is send the current value
to a text box, then change the BoundColumn and send the
value again (without having to select a different record
and come back.)

If you can help with this I'd really appreciate it.

(e-mail address removed)
-MDH
 
K

Ken Snell

No need to change the bound column. Simply use the .Column property of the
listbox.

The first column in the listbox's RowSource query is column 0; the second is
column 1; etc.

So, if you want the value from the second column, use
Variable = Me.ListBoxName.Column(1)
 

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

ADDING values from one listbox to another on same form 1
can't retrieve value of Listbox control 4
Auto populate value from one task to another in MS PROJECT 0
Save and retrieve listbox selections 1
Passing values of listbox to other form's combobox 1
Listbox Help (remove selected item) 1
Finding the right style field in VBA 0
Retrieving a Value from a Query 2

Top