I have a collection. I add them using a unique identifier. However, before adding a new one, I verify something. If that is the case, I remove the related item from the collection, by using its key, update something in its content, and insert the item back into the collection by using the same key.

So, it goes like this:

' Get the item from the collection
loObject = oInnerJoin.Item(lnKey)

' Remove the item from the collection
oInnerJoin.Remove(lnKey)

' Set the search criteria to True
loObject(1) = True

' Add the updated item in the collection
oInnerJoin.Add(loObject, lnKey, 1)

So, in a specific logic, this is executed three times on the same key. The first two times, it works. I see the collection item being removed and added back with the object loObject(1) item. However, on the third time, it gives this:

"Add failed. Duplicate key value supplied."

Anyone would be able to explain that?