try this :
if you modified the SQL, please make the SQL in "ONE" line...
for example :
select * from table <==== ONE line (ok)
select *
from table <========== TWO lines (no) (the recordset will disappear )
then the recordset will not disappear ....
try it..