sunwindandsea
Programmer
First time creating an Access database and I'm having trouble figuring how the code to udpate a field,"Last Edit Date" whenever any field in the record is changed.
Data
Event
On Change
Private Sub e_Mail_AfterUpdate()
tblContact.Last_Edit_Date = Now()
End Sub
doesn't work Obviously there is a way to change the date-time stored in a date field in the record if any field in the rerdord is changed. I just having trouble writing the code.
Thanks,
Ed
Data
Event
On Change
Private Sub e_Mail_AfterUpdate()
tblContact.Last_Edit_Date = Now()
End Sub
doesn't work Obviously there is a way to change the date-time stored in a date field in the record if any field in the rerdord is changed. I just having trouble writing the code.
Thanks,
Ed