John W. Colby
jwcolby at colbyconsulting.com
Wed Apr 28 07:51:59 CDT 2004
Capture it in OnCurrent (as you move to the record). That way you already have it when the delete occurs. When you sense the delete, store that already captured value. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan Sent: Wednesday, April 28, 2004 8:18 AM To: Access List Subject: [AccessD] Capture value when deleting a a record In an Access 97 application, I have a form that displays records from a table. When a user deletes a record, I want to first capture the value in the key field and store it in a variable. However, when the OnDelete event occurs, the record has already been deleted to a buffer. I've also tried Form_Current but it's not available there either. Aside from capturing all the possible keystrokes (that will delete a reord) in KeyDown, how can I capture a field value on a delete? Thanks, Barb Ryan -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com