[AccessD] Using the Bookmark property

A:

First, save the Key in a long field - lngPrimaryKeyID = fldMyTableID

Then after editing reposition the recordset with:

        Me.RecordsetClone.FindFirst "fldCustomerID = " & lngPrimaryKeyID 
        Me.Bookmark = Me.RecordsetClone.Bookmark 

Probably twenty better way to do this but this is what I use and it seems to
work.

HTH

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, December 20, 2007 9:36 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Using the Bookmark property

I have a continuous form, on whose footer is a button to allow editing of
the selected row. A dialog pops up, allows editing, then closes. The record
selector keeps returning to the first record rather than the just-edited
record. I cannot remember how to use the bookmark property to grab the
record about to be edited, then return to it following the edit.

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.17.5/1190 - Release Date: 12/19/2007
7:37 PM