Date Modified?

[racemadnss]

Hi

I am trying to create a date modified field for one of my forms, and I dont see anywhere in the form properties for "onSave"

Whats the next best thing?

I tried this with no luck

Public Sub Form_AfterUpdate()
    Dim updatecheck
    updatecheck = 1
End Sub

Public Sub Form_Close()
    If updatecheck = 1 Then
    [DateModified] = Now()
    End If
End Sub

I made them pubic so that the updatecheck would be shared, but its not working

 

[The_Doc_Man]

try the BeforeUpdate event. Using AfterUpdate, you are changing the date AFTER you write back the record. When it is TOO LATE.