Sql

rs.open (select * from tblname where fieldname='value')

I want to declare above line in a variable and execute later.

Thanks for help.

no need...just execute when you need it

dim sql as string
sql="select * from tblname where fieldname='value'"

cnn.execute(sql)