date of last data change

  • Thread starter Thread starter Silvio
  • Start date Start date
S

Silvio

I have a table with 3 fields [DateIn] [Rates] and [LastModified]

DateIn default value it is set to Now() in the table

When a user enters a new record he is required to enter a Rate only. The
system will populate the filed DateIn automatically and at this stage the
LastModified field NOT have any value since the initial [Rate] has not been
modified yet.

Then, the user can open up a form and update the [Rate], if needed. This is
where I need to start to keep track of the DateModified only after the
initial Rate changes not the initial setup.

I tried to set me.LastModified = Now() in before update, after update, on
change, on dirty and nothing seem to work as I expect meaning the system
enter the LastModified date even on the initial entry (the same form is used
to enter new records). Any suggestion?
 
Silvio said:
I have a table with 3 fields [DateIn] [Rates] and [LastModified]

DateIn default value it is set to Now() in the table

When a user enters a new record he is required to enter a Rate only.
The system will populate the filed DateIn automatically and at this
stage the LastModified field NOT have any value since the initial
[Rate] has not been modified yet.

Then, the user can open up a form and update the [Rate], if needed.
This is where I need to start to keep track of the DateModified only
after the initial Rate changes not the initial setup.

I tried to set me.LastModified = Now() in before update, after
update, on change, on dirty and nothing seem to work as I expect
meaning the system enter the LastModified date even on the initial
entry (the same form is used to enter new records). Any suggestion?
Click to expand...

BeforeUpdate

If Not Me.NewRecord Then
Me.LastModified = Now
End If
 
Works great. Thank you!

Rick Brandt said:
Silvio said:
I have a table with 3 fields [DateIn] [Rates] and [LastModified]

DateIn default value it is set to Now() in the table

When a user enters a new record he is required to enter a Rate only.
The system will populate the filed DateIn automatically and at this
stage the LastModified field NOT have any value since the initial
[Rate] has not been modified yet.

Then, the user can open up a form and update the [Rate], if needed.
This is where I need to start to keep track of the DateModified only
after the initial Rate changes not the initial setup.

I tried to set me.LastModified = Now() in before update, after
update, on change, on dirty and nothing seem to work as I expect
meaning the system enter the LastModified date even on the initial
entry (the same form is used to enter new records). Any suggestion?
Click to expand...

BeforeUpdate

If Not Me.NewRecord Then
Me.LastModified = Now
End If
Click to expand...
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top