time stamp record without overwriting previous time

  • Thread starter Thread starter JOE POLLOCK
  • Start date Start date
J

JOE POLLOCK

I have a form which records the last modification of a form. How can I go
back and update information on each record and while modifying the current
time I do not want to remove the previous modification time.
 
Since one record can be updated many times, you will need a related table
where you add a record each time an update occurs.

Say your form's table has a primary key field named ClientID. Your related
table will have fields like this:
- ClientID Number
- UpdateDT Date/Time

Then use the AfterUpdate event procedure of your form to execute an append
query to add a new record to that table, with the ClientID value in the form
and Now() as the date/time value.
 
Back
Top