Invalid resultset state for update (Error 40026)

You attempted to call rdoResultset.Update when the current row pointer was not pointing to a valid row, or the result set was marked as invalid. This occurs if:

• The current row pointer is pointing at EOF or BOF.
  
  
• The result set has been marked invalid due to a call to a method such as Cancel.
  
  
• An SQL error occurs.

Also, deleting a row will mark it as invalid.

To avoid this error, check the state of the BOF and EOF properties before calling Update, and make sure no method was called prior to calling Update that would mark the result set as invalid.