Nick's suggestions were sound, but have you considered using Show() and Hide() instead of opening and closing the forms? That way the tables would remain open in each form.
HTH
Barbara
>Dear all,
>
>In my project, all forms are designed to visit the tables by setting dataenvironment autoopening and autoclosing. By clicking on commandbuttons, the forms switch from one to anothers, with releasing the current form and then do form 'THETARGET' form. The problem is when I open the new form, occasionally it report problems to open the tables. Should I close the tables before I release the current form? Or otherwise something wrong in programming methodlogy.
>After the new form exit, I release the current form again and return to the original call form.
>
>
>With regards,
>
>Ransome So