retrieve multiple values from a listbox?

  • Thread starter Thread starter Michael House
  • Start date Start date
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
 
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)
 
Back
Top