SHOW LAST UPDATE FIELD 1

[dk99]

Is there a way I can show the date the field was last updated/saved on a form ?

 

[alvechurchdata]

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

 

[dk99]

What code would I need to use for that ?

 

[eadiem]

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