Kevin-

>The Data Environment has two local views in it:
>v_codes -- picklist table (parent table is codes)
>v_documents -- drives the grid on tab 2 (parent table is procdure)
>
>The form has a combo list that is an sql query of codes and it creates a cursor called doc_type. I use msgsvc.dbf to define all of the captions and labels on the screen -- eg. lblName=msgsvc("This would be the name caption")
>
>The DE.beforeopentables() has
>

>public pcGroup
>pcGroup="%"
>

>This is used so v_codes is populated for the query mentioned above.

Er. Okay. I don't get it but you haven't shared what your view definition is (not that I'm not asking for it).

>No other data type calls in the form's init(), and the form's queryunload() has a
>

>Release pcGroup
>

>
>Which doesn't seem to release the variable.

*sigh* Words like "seem" are troublesome. It is possible to _know_, and it leaves me with more questions. Put a break point on the line, and step thru the line. Check your publics, is it or is it not released? (You might find it easier to put a break point on a dummy line of code after the release, like x=3.

I thought that this might be the culprit so I added release pcGroup to the DE.afterclosetable(), but I still have open tables after I close the form -- however it might still be related??

I must be really dense today, but I don't see how a variable assigned to a character would in any way affect a table being closed.

>If I run the form and then immediately close it via the cancel button (thisform.release() is in the cancel.click() method) or via the window's "X" close icon, I have the following tables open:
>

>Doc_type
>Msgsvc
>Procdure
>Codes
>

And, where are these tables _opened_? Are they in your DE? Do they participate in the local views? (I saw above that Msgsvc is at least opened as the result of a SQL Query in a combobox.) If so, then you probably don't want them in your DE, or you want to have added them to your DE _before_ your local view.

>Thanks for your help,

If only I had been so.