David,

Thanks to those who reply. I come across this commands CREATE VIEW and SET VIEW. CREATE VIEW save the current environment and SET VIEW restore the environ. but it does not save the record number...


>Allan,
>
>So then you must take care to save and restore all of the record pointers and make sure that you don't close any of the tables that came from the initial form's DS. You should also make sure that you have an empty DS in the report.
>
>>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.