Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Triggering an Event when new record is created

Status
Not open for further replies.
homeguard

homeguard

IS-IT--Management
Jul 12, 2007
47
US
Hello,

I need to run a series of code when the user saves a new record. The problem is i only want this code to be run once when the user saves the record for the first time. anyone have any suggestions on how to do this?
 
Sort by date Sort by votes
Do you mean the Before and After Insert events?
 
Upvote 0 Downvote
Use a Static variable in the BeforeInsert event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
602
dhookom
dhookom
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
720
BJZeak
BJZeak
BlakeLacy1
  • Locked
  • Question
COPY ALL FOLDERS AND CONTENTS TO A NEW LOCATION
Replies
4
Views
359
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Output To fails when name contains forward slash 1
Replies
7
Views
418
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
626
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top