Event Log field

[dennis g]

Have a table where military traffic movment is recorded. One field, History, is a memo field where the comments for each movement is entered. I want to set up this field so each time someone clicks in the field to update the record, a string is generated and placed in another field 'event log' that states "This record was updated YYYYMMDD (current date and time)". This must append to the field, not overwrite. Any ideas?

 

[AlanS]

You may want to create the event log entry only when a user changes the memo field, rather than merely clicking in it, so that only actual modifications are recorded. In the event procedure for the appropriate event (On Update or Click) for the memo field, put the following code:

If Not IsNull(txtEventLog) Then txtEventLog = txtEventLog & vbCrLf
txtEventLog = txtEventLog & "This record was updated " & Now()

 

[dennis g]

Your suggestion worked great. I was lost trying to use GetChunk and AppendChunk, so I was trying to make it a lot harder than it was. Thanks for the KISS method.