Hi!

The copy of data from SQL query is stored in the LIST array. Its dimensions are:
dimention listbox.List(listbox.ListCount,listbox.ColumnCount)
Youc an loop through values in the LIST array to get ID for each row and assign the picture for each row. All values in the LIST array are character, so use val() function to convert character ID value to numeric.

HTH.

>I have a list box who's data is sourced from an SQL statement. In that statement the record id, description and a summary value is added. It is a list of trade descriptions and how many hours booked against them.
>
>The record id value is not displayed by using the column width = 0.
>
>I want to add icons to each of the trade id values, but want to know how do I determine what each item in the list owns what id.
>
>I am new to this and not totally familiar with the properties, just yet.
>
>Thanks in advance.