The form_BeforeUpdate event

[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

 

[GPO]

Sorry, I included a confusing typo. The last sentence should read "...is
going to be an insert, an update, or a delete?..."

 

[Allen Browne]

Test the NewRecord property of the form:
If Me.NewRecord Then MsgBox "Insert" Else MsgBox "Update"

It won't be a delete.