which event procedure to use when a record is saved

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I need to run some code as soon as a record is saved in a form. That is,
immediately after a record is saved, but not before.

Is it better to use After Insert or After Update for this purpose?

Thanks in advance,

Paul
 
AfterUpdate will fire for both newly inserted records or existing records
that were updated. Is that what you want?

Larry Linson
Microsoft Access MVP
 
I only need it to run when I first add a new record. I can't have it run at
any other time. So it seems like I should use the After Insert event. So
I'm glad you pointed out what happens with the After Update event. Thanks,
Larry.

Paul
 
Back
Top