Hi Bill
I think you mean Form_BeforeUpdate don't you? I would think that updating the record in AfterUpdate could cause an endless loop J
Cheers,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 12 February 2015 09:29
To: MS_Access_Professionals@yahoogroups.com
Subject: [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
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
Posted by: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar