new record identifier

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

Is there a flag that will identify if a record is new? I have a process that
I only want to run when the record is new, after that I do not want it to
run.

Specifically, I have an engineering change databaser and what I am trying to
do is to record the inventory balances when teh engineering change was put
in. After this initial entry, I do not want to update the inventory balance
if people view or edit the record, so basically I just want this even to
fire once.

If I know of a way to identify that the record is new and test for that
when the form is closing, I could then shoose to write the inventory
balances to the database or not based on that value.

Thanks

Joe
 
The form has a NewRecord property. You need to check in the BeforeUpdate
event. When the form is closing (the Unload or Close events) is too late,
the record has already been saved at that point and NewRecord is no longer
True.
 
Back
Top