<div>
One important point on bookmarks; the values don't survive a requery or anything that causes the recordset to be re-created (a close and open).<br />
<br />
They are only valid for the current recordset. &nbsp;Once you close it or requery it, any saved bookmark values are invalid. <br />
<br />
&nbsp;So it's not something you can save forever. &nbsp;It's sole purpose is to be able to move back to a given record quickly in a recordset that your currently using. &nbsp;In using it, you don't need to save a key for the record, then do a find. &nbsp;That is however what your forced to do if you can't use a bookmark (say because you are doing a requery).<br />
<br />
Jim.
</div>


One important point on bookmarks; the values don't survive a requery or anything that causes the recordset to be re-created (a close and open).

They are only valid for the current recordset.  Once you close it or requery it, any saved bookmark values are invalid.

 So it's not something you can save forever.  It's sole purpose is to be able to move back to a given record quickly in a recordset that your currently using.  In using it, you don't need to save a key for the record, then do a find.  That is however what your forced to do if you can't use a bookmark (say because you are doing a requery).

Jim.

<div>
<div class="content wysiwyg-content">
I'm working with an old Access 2003 database and on a particular form there is a combobox. &nbsp;In the afterupdate event of the combobox is this line of code:<br />
<br />
If Not rs.EOF Then Me.Bookmark = rs.Bookmark<br />
<br />
Can someone tell me what it does?<br />
<br />
--Steve
</div>
</div>


I'm working with an old Access 2003 database and on a particular form there is a combobox.  In the afterupdate event of the combobox is this line of code:

If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Can someone tell me what it does?

--Steve

What is this line of code doing?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.