2 programers have 2 different ways of opening recordsets.

1st way - retrieve 1 record to Update
VB Code:
  1. With DataEnvironment1.rstblLabs
  2.         If .State = adStateOpen Then .Close
  3.         .Open "SELECT * FROM tblLabs WHERE pkLab = " & p_pkLab, _
  4.                 , adOpenStatic, adLockOptimistic
2nd way - retrieve all records to fill a combobox
after the 1st way has already happened
VB Code:
  1. With RS
  2.         If Not .State = adStateOpen Then
  3.             .Open , , adOpenStatic, adLockOptimistic
When the second query to this table is executed the only
record retrieved is the one from the 1st query. Is there any
way to clear out the selection string from the 1st query and
just retrieve all the records without passing a new selection
string? This code is everywhere in the program so a major
code change would be good to avoid.