Runtime error '2115'

[osx99]

I have a 'modifieddate' field which I am trying to update only when someone makes a change to the data using the following code placed in an event procedure for after update of my form

Private Sub timestamp()
Me!DateRecordModified = Format(Now, "dd/mm/yyyy hh:nn&quot
End Sub

However, this gives a runtime error 2115 "The macro or function set to the BEforeUpdate or Validationrule property for this field is preventing Microsoft Access from saving the data in the field"

Can anyone help?
Thanks,
Osx

 

[Steve101]

You need to trigger this code in the BeforeUpdate event of the form. I think you have it triggered in another event (as suggested by the error).

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)