update form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a field called "Status". I would like an another field on
the form called "Last Update" to be updated with the current date and time
whenever the value in "Status" field is changed. Both field are linked to an
underlying table.

Thanks!
 
Warning change the name of "last update" to last_update or lastupdate or
something similar as last and update are reserved words in access. I think
status is also a reserved word.

In the AfterUpdate event ofn the field "Status" enter the following

me!last_update = now()
 
Back
Top