Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    36

    Unanswered: can't get bookmarks to work

    Hi, I can't seem to make bookmarks work. I set up a recordset rs and a clone rsclone. I do a findfirst and then add a record if nomatch. then I need to requery I want the new record to be displayed on the form. I've tried setting a strbookmark string, then what seems like every concievable combination of strbookmark,rs.bookmark,rsclone.bookmark,and rs.lastmodified with = sings mixed in and the result is allways the same which is that the form adds it's record then goes to the first record.
    Any help would be appreaciated.
    Thanks
    Raif

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi Raif

    As I understand it (which could be wrong!) bookmarks ar lost if you requery the recordset, therefore you cannot go to the book mark after requerying!

    The solution is to set a variable(s) equal to the value of the key field(s) which will not change and is(are) unique to the record added. Then use find/findfirst after requerying.

    HTH

    MTB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •