Automatically update an AmendDate field on my form using VBA

[Clarkyboy420]

Please Help!

Am trying to get a form to automatically populate an amend date field upon
any change to the record.

I've tried the following in the form level Form_AfterUpdate Event

Private Sub Form_AfterUpdate
Me.IncidentAmendDate = Date
End Sub

This correctly populates the field on the form, but then won't let me move
to any other record, exit the record etc unless I dont save.

Please advise!!!

 

[John Spencer]

Try moving the code to the form's before update event

Private Sub Form_BeforeUpdate
Me.IncidentAmendDate = Date
End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County