Automatically update an AmendDate field on my form using VBA

  • Thread starter Thread starter Clarkyboy420
  • Start date Start date
C

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!!!
 
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
 
Back
Top