Deleting a ListBox Selection

[dreamnauta]

In my efforts to become more efficient at VBA, I am requesting help from you guru's once again



I have a bound Combo box. When the user makes a selection, the selection (String) is then added to a List box. Although I don't like the idea of a bound Combo box I am going to stick with it for now. However, here is my question. The List Box receiving the values from the bound combo box is not designating the item as a list box item. I want the user to be able to delete an item in the list. For example when I run this code

Dim i As Integer
For i = listBox.ListCount - 1 To 0 Step -1
   If listBox.Selected(i) Then listBox.RemoveItem i
Next i
End Sub

I get a runtime error : "unable to remove item, 0 not found in list"

Is the listBox not recognizing the data because it is from a bound query?

How do I resolve this problem?

Any help is much appreciated!

[June7]

I think RowSource property setting conflicts with AddItem and RemoveItem.

[dreamnauta]

Is there anyway to work around this, or should I just go ahead and make an unbound selection list, and add the entries manually?

[June7]

No workaround that I know of. Must do one or the other.

[dreamnauta]

Thanks for your help! It wasn't a conflict with the row source, just a logic error on my part, I told access to look at the wrong listbox!