[AccessD] Capture value when deleting a a record

Barbara Ryan BarbaraRyan at cox.net
Wed Apr 28 07:59:23 CDT 2004


I will look at my code again and try to see what the heck I'm doing!  Thanks


----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Wednesday, April 28, 2004 8:47 AM
Subject: Re: [AccessD] Capture value when deleting a a record


> On 28 Apr 2004 at 8:17, Barbara Ryan wrote:
>
> > 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.
>
> No it isn't. It does not get deleted  until after the OnDelete and
> before the DeleteConfirm.
>
> You *can* store the current Key in the OnDelete into a form or global
> variable. I do it frequently.
>
> >I've also tried Form_Current but it's not available there
> > either.
>
> You must be doing something else wrong. It is also available there (I
> capture it at that point on occasions as well)
>
> How about posting your form's code to see what is happening?
>
>
>
>
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System
> Support.
>
>
>
> -- 
> _______________________________________________
> 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