Link to home
Start Free TrialLog in
Avatar of bshort1023
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
ASKER CERTIFIED SOLUTION
Avatar of stevbe
stevbe

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial