Cannot Reset Bookmark from Recordsetclone
Posted on 2006-10-19
I am setting a bookmark of a recordsetclone and then requerying the data. When I try to set my recordset back to the original record I get the error message "No Current Record".
This is all happening in the Form_Timer Event
Dim rs as Dao.Recordset
Set rs = Me.Recordsetclone
rs.Bookmark = Me. Bookmark
Me.Bookmark = rs.Bookmark ' This is where the error occurs.
I have tried a few different variations on this (i.e. forms!formname.bookmark).
Where am I going wrong?
Bill from PA