Huh? Oh...strayed off of the track........
OK, what you were trying to say, in part, was that in a parent-child Form relationship, if you use a Private datasession in the parent Form, you use the Default datasession in the child, allowing the child to inherit the active datasession, right? You do not open or close tables or even have a datasession in the child form in these circumstances.......
>Oversimplified :-) to the extent of losing contents ...
>
>>To simplify Ed's reply (bg), both forms are using the Default datasession, most likely. Meaning, if one form closes the tables, the other form can't find them anymore. You can set AutoCloseTables to False (.F.) in one of the Forms to resolve this, but the true resolution depends on the relationship (parent,child) between the Forms, if any.
>>
>>
>>>I have a form with 2 tables
>>>if I open a second form over it, when I get back
>>>to the first form, is not possible to find the tables.
>>>
>>>I think this is not the right way to do.
>>>
>>>What the right way to open a form over other form?
>>>
>>>I heard about child form. How that works?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05