Runtime error when attempting to update form

[mpetersen]

Hello,
I get the following error when any user attempts to make any change to a particular form in my db.

Run-time error '-2147352567 (800200009)':
Update or CancelUpdate without AddNew or Edit.

The code throwing the error is:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Date_edited = Now()
End Sub

Any ideas what I'm doing wrong?

Thanks,
mlp

 

[jsv2002]

Do the properties of the field in the table match those of that on the form as I tried the above with an unbound text box and got 23/03/2009 15:43:15 outputed so maybe the table field format is set to just 23/03/2009 (Date type) therefore cannot update?

Just a thought good luck John