Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 572
  • Last Modified:

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
0
bshort1023
Asked:
bshort1023
1 Solution
 
stevbeCommented:
first ...bookmarks are only good for the "life" of a recordset and .requery disposes and re-creates the recorsdset so using the previous bookmark (while usually works) is not actually a vaild process.

I would grab the value of the Primarykey field and do a find first ...

Dim lngID As Long

lngID = Me.cboID.Valuers
Me.Requery
Me.Recordset.FindFirst "ID=" & lngID

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now