I am trying to show pictures in a listbox. I use the code below to add the pictures. It works and the pictures are added but when I scroll down or click on an item the picture reverts back to the picture property for the listbox control which is (none) in my case. This appears to only happen when the rowsource is a SQL statement, other rowsource types function as expected. Is there a trick to getting around this while still using SQL as the rowsource type?


FOR iItem = 1 TO THIS.parent.lstFU.ListCount
iStat = VAL(ALLTRIM(this.parent.lstFU.List(iItem)))
DO CASE
CASE iStat = 2
THIS.parent.lstFU.Picture(iItem) = "c:\mba_Dev\bitmaps\record.bmp"

OTHERWISE
THIS.parent.lstFU.Picture(iItem) = "c:\mba_Dev\bitmaps\record.first"

ENDCASE
ENDFOR