Access Recordset Bookmark Elements RRS feed

  • Question

  • While trying to reference the current record in a recordset I have been using the Locals window to expand the recordset Bookmark property, and on expanding that Bookmark property I find that it has four elements.  The first (0) is clearly the record (or row) number, but elements (1), (2) and (3) contain numbers for which I can see no logical origin.  The Microsoft Help page offers no guidance, and a trawl through the internet has proved unsuccessful.  Does anyone know what they mean or if it matters anyway?  Any help will be much appreciated.

    Andy C

    Saturday, June 22, 2019 9:48 PM

All replies

  • The bookmark property should not be picked apart, since as you found out it is undocumented. It should only be used to synchronize a form and a recordset:

    with me.recordsetclone
      .findfirst "PK=123"
      me.bookmark = .bookmark   'moves the form to that record.
    end with

    -Tom. Microsoft Access MVP

    Sunday, June 23, 2019 4:16 AM
  • Tom

    Thanks for the reply.  I guess that if it is undocumented it does not matter what it means.

    Andy C

    Sunday, June 23, 2019 7:51 AM