thanks for ur quick reply.
and just one more question

u mean to say,
this statement is optional
that is, if i do not write it and just say
set rs=nothing.

also please let me know
which approach is better

using a
select * from table in rs.open
and then using filters and finds to manupulate the recorset.

or

using a conditional statement in rs.open and when we have finished
then close the recordset and then
again open the recordset with a diffetent select statement and work on it.
and finally set rs to nothing.
here i just wanted to know if opening the recordset a number of times will make my program slow or any other knid of problem.

i really have a lots of questions on these.
so please help me.

thanks and thanks a lot.