CODEWITHSUNDEEP
ms-accessms-access-2007vba
waanders
waanders

Reputation: 9083

Retrieve column values of the selected row of a multicolumn Access listbox

How can I retrieve the value of specified column of the selected row in a multicolumn listbox?

I populate the listbox by setting the RowSource property with a SQL string. BoundColumn set to value 1.

I can retrieve the value of the bound column (of the selected row) by using ListBox.Value. But I also want the value of another column.

Upvotes: 19

Views: 127951

Answers (3)

Noble Issac
Noble Issac

Reputation: 21

For multicolumn listbox extract data from any column of selected row by 

 listboxControl.List(listboxControl.ListIndex,col_num)

where col_num is required column ( 0 for first column)

Upvotes: 2

Kristian
Kristian

Reputation: 416

Just a little addition. If you've only selected 1 row then the code below will select the value of a column (index of 4, but 5th column) for the selected row:

me.lstIssues.Column(4)

This saves having to use the ItemsSelected property.

Kristian

Upvotes: 15

RolandTumble
RolandTumble

Reputation: 4703

Use listboxControl.Column(intColumn,intRow). Both Column and Row are zero-based.

Upvotes: 24

Related Questions