Problems storing a Collection within a Collection. Is this possible?

Forgive me but I cannot post examples as this is confidential information. I have changed the labels to be for a car dealer to protect the information that I am working with.


Is it possible to store 1 collection in another collection?

Given a collection called Dealer and another called Inventories.

Please Login or Register  to view this content.

Loading each individual collection seems to work as I can print off make, model, and all the VINs and prices underneath. But I am not so sure I am collecting all of the Inventories for each Dealer rather it seems I only have the last one.

Are you defining classes in a class module or making Collections in a normal module?

I don't see the variable Dealers defined (nor DealerObj or InventoryObj).

In any case, yes collections can hold other collections. You can even add to the sub collections after they are added to the outer collection.

Please Login or Register  to view this content.

does not crash in the last line.

Thanks for the help! In reviewing your code and looking back at mine I found that I didnt set my sub collection up properly. I fixed it and it now appears to be working just fine.

Thanks for the nudge in the right direction.