I have a table with a "LastUpdated" field which is planned to carry
the date that changes were made. If the record is viewed the field
should not be changed.
About ten years ago I had advice for a similar problem from which I
have made this code:
If Me.Dirty = True Then "lastUpdate = Date()
The question is where do I add the code?
My attempt failed:
Private Sub Form_AfterUpdate()
If Me.Dirty = True Then "lastUpdate" = Date()
End Sub
Many thanks,
Robin Chapple
__._,_.___
Posted by: Robin Chapple <robinski@westnet.com.au>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar