[AccessD] Unable to bookmark after record is deleted

Lonnie Johnson prodevmg at yahoo.com
Tue Nov 14 18:39:45 CST 2006


Gustav,

You're the man. That did it for me. Never worked much with bookmarks in this capacity. I am all the smarter now because of you.
 








May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us






 



----- Original Message ----
From: Gustav Brock <Gustav at cactus.dk>
To: accessd at databaseadvisors.com
Sent: Tuesday, November 14, 2006 5:53:13 AM
Subject: Re: [AccessD] Unable to bookmark after record is deleted


Hi Lonnie

When you delete a record the bookmarks are destroyed.
Before you delete, retrieve the ID of the bookmarked record, delete, locate the bookmarked record by its ID, and reestablish the bookmark.

/gustav

>>> prodevmg at yahoo.com 14-11-2006 05:28:31 >>>
I have a process that deletes a record in a recordset of a subform via vba, then requeries the subform object. Then I try to move to another record using the bookmark and I get a message that says there is not current record for the recordset clone of the subform?  I know there are records, this only happens when I delete or insert a record into the underlying recordset.


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




More information about the AccessD mailing list