Auto-date in forms when records change

  • Thread starter Thread starter Gordon Pim
  • Start date Start date
G

Gordon Pim

I know I've done this before, but cannot remember how to do
it. I want to include a date field within a form that
displays the last date that record was updated/edited. Can
anyone assist with my request?

Many thanks!
 
Use the Form_BeforeUpdate Event to change the value of the Field
[DateLastUpdated] to Date().
 
Hallo,

Before update

me.DateLastUpdate=Now()

To top it you could also make a field DateCreated and set the default value
in the table to now().

Put both fields on a form *locked* and your user will by happy ;-)

Regards,

Harmannus



Van T. Dinh said:
Use the Form_BeforeUpdate Event to change the value of the Field
[DateLastUpdated] to Date().

--
HTH
Van T. Dinh
MVP (Access)



Gordon Pim said:
I know I've done this before, but cannot remember how to do
it. I want to include a date field within a form that
displays the last date that record was updated/edited. Can
anyone assist with my request?

Many thanks!
Click to expand...
Click to expand...
 
Back
Top