>>>>The load of my base form is where I set delete, exclusive etc.
>>>>If I add a table to DE ( private data ) and then run form, if the first record is deleted it shows up. I go to BeforeOpenTables and set dele on and this is cured because it fires before load of form. Is there a way to set this as default for BeforeOpenTables ?
>>>>
>>>>Thanks!! CB
>>>
>>>I have a method in my base form called .SetEnvironment() which does what your load is doing. The only difference is that I make this call as the first statement in the .BeforeOpenTables event of the DE. That way I know the environment is set when it gets to opening the tables.
>>>
>>>Steve
>>
>>Yes good idea !! But do you have to go to each form that you use DE on and add .SetEnviroment() statement in .BeforeOpenTables or is there a way to define that as default for .BeforeOpenTables ?
>>
>>CB
>
>Unfortunately, the form classes don't have a dataenvironment so you do need to go to each form that you have and put that call in. Pain in the butt. At least the .SetEnvironment() method makes life a little easier.
>
>Steve

Thanks for help !! I did not think it could be done as default because of no DE in form class. It is however the best place to set enviroment for me because I use a lot of views and SQL in combo and if you don't set talk off in BeforeOpenTables you see result messages ( and of course the deleted problem mentioned above ). I do like the SetEnviroment() rather than load and have already changed my base form. Thanks again !! CB