Glen, thank you very much.
>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,
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham