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