Update Record

  • Thread starter Thread starter Piggy
  • Start date Start date
P

Piggy

I have a problem with the following case:
I have 2 columns naming 'Value' and 'LastModifiedTime'
For the column 'LastModifiedTime', I have set the default
value to be the system date and time.
May I know if i ever update the record in the 'Value'
column, is there any method that it can automatically
update the system date and time in the
column 'LastModifiedTime'?

Thank you.
 
You can use the OnChange event in the Value field to
update the latest revision time:

Me.[LastModifiedTime] = Now()
 
I have a problem with the following case:
I have 2 columns naming 'Value' and 'LastModifiedTime'
For the column 'LastModifiedTime', I have set the default
value to be the system date and time.
May I know if i ever update the record in the 'Value'
column, is there any method that it can automatically
update the system date and time in the
column 'LastModifiedTime'?

Thank you.
Click to expand...

There is no way to do this in a Table - tables have no usable events.

If you (as you should!) use a Form to edit the data in your table, you
can put code in the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
Me.LastModifiedTime = Now
End Sub
 
Back
Top