When Data Entry or Editing actions are performed on important Tables in Databases a Time-Stamp with User Name is normally saved on each record to mark that event. This is done through the Form's Before Update Event Procedure. A sample procedure is given below:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![EditedBy] = CurrentUser
Me![EditedDt] = Now
End Sub
Download Free Software:Desktop Utilities, Mobile Communication, Games etc.
