form BeforeUpdate/BeforeInsert clarification

[Cowboy_BeBa]

hi

ive got a form, it has 5 fields, im developing some code that i want to run just before the record is officially added (so in that millisecond in between a user completing data entry in all 5 fields and before the record is stored in the table)

Just curious if the right event to use is the before update or the before insert (or neither?), what is the difference between the two?

 

[Galaxiom]

In a Bound Form it would be the BeforeUpdate event of the form.

BeforeInsert fires the moment you begin a new record by typing into a control that is bound to the recordset.

However BeforeUpdate will also fire when the record saves after any change. To just fire on new records test the form's NewRecord property for True and proceed accordingly.