Last Update Date on Form

[Cameron]

I have a form with a Tab Control Box and various
subforms. Is there a way to display a date on the form
and/or subforms informing users when the last data entry
or edit was performed.

Thanks.

 

[Allen Browne]

Access does not give you this automatically, but it's easy to do if your
edits are always performed through forms.

Add a field to each table named (say) LastUpdated - Date/Time type.

In the BeforeUpdate event of the form, set the value of this field:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[LastUpdated] = Now()
End Sub