bshort1023
asked on
Cannot Reset Bookmark from Recordsetclone
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.Requery
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?
Thanks,
Bill from PA
This is all happening in the Form_Timer Event
Dim rs as Dao.Recordset
Set rs = Me.Recordsetclone
rs.Bookmark = Me. Bookmark
Me.Requery
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?
Thanks,
Bill from PA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.