>>>
>>>So does the form.Unload() run ? Does the datasession disappear from the Datasession window after the form is released ?
>>>
>>
>>Now that I learned from Jim Winter how to view Data Session window as the form is opened and closed, I observed the following.
>>When the form is closed Data Session shows a session Unknown(4) which has alias of the cursor created in the modal (private data session form). And this cursor was created with SQL Select From the table with which I am/was having the problem. I don't know if it means anything though.
>
>It means there is a dangling reference as Viv suspected. Now becomes the fun part <g> You have to figure out what does create it. Are you storing some other forms as this form object property?
I don't think so. But,as you said, the fun now begins as I will be looking for the dangling reference. Thank you for your help.
"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