Dimitry

>1. Add a property .oCaCollection to the form. Object reference to each CA should be in scope for the life of the form so I want to use the form property for that.

I like an individual property for each ca because it feels easier to debug and reference. Less flexable than a collection, though. Otherwise I don't see why it wouldn't work.

>2. Add element to collection .oCaCollection for every CA/table I need to open in the form.
>3. In LOAD method of the form create all CA's/cursors keeping the reference of each CA to an element in .oCaCollection.

Use the INIT instead of the LOAD. If the form gets instantiated/released multiple times there may be major blowups sometime in the future. Something is going on under the hood in the LOAD, and I don't know what it is. Whatever it is, it has given us major headaches a couple of times and it is alleviated when everything is move into the INIT.


>4. When form is closed, in UNLOAD method, release all CA objects.

Sounds okay to me. Might have a specific method that adds CA refs to the collection and another specific method that removes them.

Have Fun...
Regards,