Hi,
I have a collection which I want to populate with some Contact objects. Each contact object has properties such as name,address etc. and are stored in a SQl database. I loop through the recordset and populate each contact object before adding it to my collection!
However, when this is done, all the objects in the collection are exactly the same .
I have stepped through in debug mode and every time it adds a new contact object to the collection, it changes all the previous objects in the collection into the new object so that when it is finished, all the objects in the collection are equal to the last one added. Why?

Any help would be appreciated

Shaun