I have defined my recordsets like this

Code:
Public Rs As New ADODB.Recordset
I Open them like this

Code:
Set Rs = New ADODB.Recordset
Rs.Open StrSql, Db, adOpenStatic, adLockOptimistic
It seems to me to be a DOUBLE "NEW"

Should it be the following -

Code:
Public Rs As ADODB.Recordset
.......
Set Rs = New ADODB.Recordset
Rs.Open StrSql, Db, adOpenStatic, adLockOptimistic
What happens when I say "NEW" ?

What is the "CORRECT" way to handle ADO Records sets ?