ACCESS FEED: [MS_AccessPros] How to add timestamp properly when adding and/or updating a form

Minggu, 16 Oktober 2011

[MS_AccessPros] How to add timestamp properly when adding and/or updating a form

Hello,

I have a table in which I have included a timestamp column in order to keep track of every time I add a new record or update an existing record.
How shall I specify the Event properties for the form that I use to handle my table?
I know that I shall add a Visual Basic line like 'Timestamp = NOW'.
But to which of all the possible Event properties shall I add this line?
Shall I add it to all the following:
After Insert
After Update
On Change
Or is there even more properties to consider?

I have tried some of these examples, but I am confused by the behavior of Access. I cannot quite figure out the logic behind.

Regards
Dennis Davidsson

[Non-text portions of this message have been removed]