Access updating existing records HELP!

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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!