Question Help! How to auto-timestamp multiple fields (Is not null)

[Ignoth]

I am trying to create a tracking system, and need to set 4 different fields to be auto timestamped "Now() " after those particular fields are filled/modified within each record without affecting the previous timestamps. Also would like to run aging reports based on those records. I just have 1 master table, I'm not sure exactly how to go about doing this.

(i don't know VBA either)

 

[Pat Hartman]

(i don't know VBA either)

I hope you're a quick learner. You can't do this without some VBA unless you want to struggle to learn how to use macros. If you're going to struggle to learn something, you might as well learn the useful thing - VBA since macros are limited and will not help you with anything outside of Access. Search here for an audit log example.
That will probably be over your head but if you need to keep a log of what changed, that's your solution. If all you care about is the most recent change, you can do that with a kludge. Add four date columns to the table. One to go with each field. Now we get to the code. It MUST go in the FORM's BeforeUpdate event.

If Me.fld1 & "" <> Me.fld1 & "" Then
    Me.fld1TS = Now()
End If
If Me.fld2 & "" <> Me.fld2 & "" Then
    Me.fld2TS = Now()
End If
....