I have a multi select list box which updates a record with the ID of the items selected in the list box - this is bound to column 1 & works all fine (code below)
However I need the list box to update 2 different fields ...
[Tickers] to be updated with CategorySelect.BoundColumn
= 1 (which is already in the code)
[TickersName] to be updated with CategorySelect.BoundColumn
Can anybody help?
Private Sub CategorySelect_AfterUpdate()
Ticker = "24, "
CategorySelect.BoundColumn = 1
For Each Item In CategorySelect.ItemsSelected
Ticker = Ticker + CategorySelect.ItemData(Item) + ", "