The form_BeforeUpdate event

  • Thread starter Thread starter GPO
  • Start date Start date
G

GPO

(Using Access 2003 (with Access tables as opposed to SQL Server backend etc))
Is there a way I can trap whether the proposed "update" that triggers the
Form_BeforeUpdate event, is going to be an insert, and update, or a delete?

Regards
 
Sorry, I included a confusing typo. The last sentence should read "...is
going to be an insert, an update, or a delete?..."
 
Test the NewRecord property of the form:
If Me.NewRecord Then MsgBox "Insert" Else MsgBox "Update"

It won't be a delete.
 
Back
Top