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