Re-query recordsets instead of reopening them

The require method of a dynaset or snapshot-type Recordset is useful if you need to gather any new rows that may have been entered since you first ran the query. Using this method will be considerably faster than creating a new recordset.

Dim rstData as Recordset
Set rstData = dbsCurrent.CreateRecordset("Long Running Query")
'... time passes
rstData.Requery        ' far faster than recreating the recordset