Rabu, 11 Februari 2015

[MS_AccessPros] Re: Use of update to "LastUpdated" field

 

Robin

Me.Dirty will not be true in the AfterUpdate event. "Dirty" means a record is in a state of being edited. What I would use is:
Private Sub Form_AfterUpdate()
    lastUpdate = Date()

End Sub

The AfterUpdate event only fires after a record has been updated.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com


__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar