I have an access database with about 3000 records, and we need to go thru this and update certain information in the records. I have created a form that has the following code...

Private Sub Form_Dirty(Cancel As Integer)
Me.Call_Date = Date
End Sub

This code, I thought, would update the CALL DATE field to the most current date once a modification has been made. It works for New records, but not working for existing records.