M Meltdown Registered User. Local time Today, 18:34 Joined Feb 25, 2002 Messages 472 Jun 26, 2009 #1 Hi all, I want to run some code in response to a new record being added. Behind what Event should I put my code: If Me.NewRecord then 'some other update code End if Thanks Regards Melt
Hi all, I want to run some code in response to a new record being added. Behind what Event should I put my code: If Me.NewRecord then 'some other update code End if Thanks Regards Melt
pbaldy Wino Moderator Staff member Local time Today, 10:34 Joined Aug 30, 2003 Messages 36,272 Jun 26, 2009 #2 Given your description, rather than using that test, you may find the after insert event more appropriate. It will only fire for a new record.
Given your description, rather than using that test, you may find the after insert event more appropriate. It will only fire for a new record.
M Meltdown Registered User. Local time Today, 18:34 Joined Feb 25, 2002 Messages 472 Jun 26, 2009 #3 Thanks very much Paul. Regards Melt