After Update / Populate current date

[Eric2013]

I'm a bit lost on this one. been following threads, trying to get this simple Event procedure to work.

i have a form with a field i'd like to put in an updated date each time the form has any kind of data added to it, or removed.

I created an Event procedure for my field "autoupdate" used ;

Private Sub AutoUpdate_AfterUpdate()
Me!AutoUpdate = Now()
End Sub

didnt work, tried the below

Private Sub AutoUpdate_AfterUpdate()
Me.AutoUpdate = Now()
End Sub

it didn't work, saved it, closed out, opened again, to that form, made adjustment, but no date populate.

did the google search for form changes and date poplulate, even got a book on access 2013 the missing manual, professional access 2013 as well.



I will have more then one person using this form on a network and it would be nice to know for inventory tracking purposes, when it was updated. at this point in time, it's a standalone on one machine. tried this on 2 different computers, and still no date on update.

Can someone point me in the right direction please...and thanks in advance.

[Missinglinq]

Place your current code in the Form_BeforeUpdate event. To populate the AutoUpdate Field when the Record is first created and any time it is edited:

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

To only update the Field when the Record is edited:

Private Sub Form_BeforeUpdate(Cancel As Integer)
 If Not Me.NewRecord Then 
  Me.AutoUpdate = Now()
 End If
End Sub

BTW: Now () will give you a date and time component. For date only, replace Now() with Date().

Linq ;0)>

[Eric2013]

Tks Linq. That worked perfect.

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>