Collection Problem

[hyousuf2]

hey
am using an object as a collection
i declare it in a module as global, the problem is if i insert the values manually it works fine but when i try to insert values from a database using a recordset and when i try to access it, it says "Object no longer valid"

[Hack]

Post what you are doing...on the surface, I don't know why you would be having a problem.

[THEROB]

I think you might be adding a reference to the recordset itself - not the actual records. Put each record into a string and then add the string to the collection.

Does this help?

[Bombdrop]

Have you looked at using a Collection Class???

[Dave Sell]

hey am using an object as a collection
i declare it in a module as global,

This in itself is the source of many problems. You should make it a Private member of your main Form, and give it Public Accessors. That way, you always know when it's available. In your case, it is likely you are using it when it is not available.