Hi! I need to be clarified with some issues.

when to Use:
1.
Code:
If rs.State = adStateOpen Then rs.Close
rs.Open sSQL, oConn, adOpenDynamic, adLockOptimistic
and
Code:
oConn.Execute
Questions:
1. Which is recommended from the two?
2. Is it always necessary to do this everytime I use sSQL = "SELECT * FROM TABLE"?
Code:
If rs.State = adStateOpen Then rs.Close
rs.Open sSQL, oConn, adOpenDynamic, adLockOptimistic
3. Which is recommeded, declare Dim rs As ADODB.Recordset in declaration area and Set to nothing every unload of the form or declare itin every Private Sub and set it to nothing in every Private Sub?