which event procedure to use when a record is saved

[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

 

[Larry Linson]

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

Larry Linson
Microsoft Access MVP

 

[Paul James]

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