Michelle,

You can still use a SELECT to generate the result, since it so small you could use TO ARRAY and base the listbox from the array which is what I'd do since you have 2 columns. Otherwise you have to use AddItem and AddListItem to get the columns to work out right.

>I don't want to put one item at a time in the listbox. It has a cursor as a rowsource and I need it that way. What I'm trying to do is in the SELECT statement, where I have it putting "R" or "" in the crepair field, have it put a picture or nothing instead.
>
>It shouldn't matter whether I'm using a listbox or a grid. Why would the SELECT care where its cursor ends up?