Have a system date or stamp date =date()
would like to know everytime a record has been changed (Last update)
If I used system date Is this correct?
Private Sub Sys_Dt_Change()
[L_Update] = Date
End Sub
please Advice
thank you
and last
Do I need a separate field for update

I use a LastUpdated field in my table (one field that gets changed with each update, not an audit trail). On the OnDirty event of the form I have

Me.LastUpdate = Date

That puts the current date in the field when any change is made to that record.