Thanks so much, Naomi. I figured it was something simple - it was as simple as a thisform.release command in the queryunload event!
>>I have a form with a private datasession that opens tables with optimistic buffering on. If the form is cancelled, the form reverts the changes and the datasession closes with the form just fine.
>>
>>However, if the record is saved succesfully, the datasession stays open after the form is closed, with the datasession listed as "unknown." I have placed a clos data command in the queryunload, which closed the tables, but the datasession still hangs on until I close the app. I'm not using any transactions and I don't think any data should be hung open, but what am I missing to get the datasession to close automatically with the form?
>>
>>Thanks in advance!
>
>It is usually an indication of the dangling object reference. Say, if you add CLEAR ALL there, will it close?
>
>You need to find out what prevents it from closing.
Steve Howie, owner
DaSH Technology
Denver, CO