>David,
>
>Thank you for the explanation, but the reason why i make Form2 DS to Default is because i run a report form which uses the DS of Form2. Setting the Form2 to Private will cause the form not to find the tables it needs.

When you run report, the record pointer would be at eof(). It should do:

local lnRecno
lnRecno=recno()
report form ...
goto m.lnRecno && So the record pointer would not move

>
>>Allan,
>>
>>Opening a Default DS form from a Private DS form will cause the "child" form to run in the same DS. So it is using the same set of record pointers. If you do not wish to have this behavior then you need to set the second form to use it's own Private DS.
>>
>>>I have created 2 modal forms (Form1 and Form2). Form1 datasession property was set to 2 (Private), while Form2 is in Default. In Form1 open the form Form2 using 'do form'. I've notice, in Data Session dlg. box, that Form2 uses same DataSessionID no. which is 2. And i when exit Form2, Form1 DataSession became 'Unknown(2)', and the index and rec. pointer of the tables was altered.
>>>
>>>Can someone pleas tell why this happen and work around to this problem...