Mar 21, 2005 #1 dk99 MIS Joined Jun 20, 2003 Messages 76 Location GB Is there a way I can show the date the field was last updated/saved on a form ?
Mar 21, 2005 #2 alvechurchdata Programmer Joined Nov 8, 2003 Messages 1,737 Location GB Add a LastUpdated field to the table and use the Form_BeforeUpdate method to store Date() in that field. Geoff Franklin http://www.alvechurchdata.co.uk Upvote 0 Downvote
Add a LastUpdated field to the table and use the Form_BeforeUpdate method to store Date() in that field. Geoff Franklin http://www.alvechurchdata.co.uk
Mar 21, 2005 Thread starter #3 dk99 MIS Joined Jun 20, 2003 Messages 76 Location GB What code would I need to use for that ? Upvote 0 Downvote
Mar 21, 2005 1 #4 eadiem Technical User Joined Apr 8, 2004 Messages 47 Location CA Alve suggested using BeforeUpdate, I prefer Dirty. Here is the code I used. Private Sub Form_Dirty(Cancel As Integer) [Date Last Modified].Value = Date End Sub Upvote 0 Downvote
Alve suggested using BeforeUpdate, I prefer Dirty. Here is the code I used. Private Sub Form_Dirty(Cancel As Integer) [Date Last Modified].Value = Date End Sub