The rdoResultset is empty (Error 40022)

You attempted to make a call to rdoResultset.Move, rdoResultset.MoveNext, or rdoResultset.MovePrevious on an empty result set.

To avoid this error, make sure the SQL statement used returns a valid result set before using any of the previously mentioned methods. You can check to see if a result set is empty by checking the RowCount property, or by checking to see if both the EOF and BOF properties are True.