Last Update Date on Form

  • Thread starter Thread starter Cameron
  • Start date Start date
C

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.
 
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
 
Back
Top