J
JimS
Using the following code, I get an Invalid Bookmark error. It appears to
happen on the last row of the filtered ADODB recordset on the "Movenext"
method...:
rstPickListDetail.Open "tblPickListDetail", cnn, adOpenDynamic,
adLockOptimistic
....
....
rstPickListDetail.Filter = "PLPicklistID=" & m_lngPicklistID
While Not rstPickListDetail.EOF
rstPickListDetail.Delete
rstPickListDetail.MoveNext
Wend
happen on the last row of the filtered ADODB recordset on the "Movenext"
method...:
rstPickListDetail.Open "tblPickListDetail", cnn, adOpenDynamic,
adLockOptimistic
....
....
rstPickListDetail.Filter = "PLPicklistID=" & m_lngPicklistID
While Not rstPickListDetail.EOF
rstPickListDetail.Delete
rstPickListDetail.MoveNext
Wend