date stamp a record

  • Thread starter Thread starter Heidi
  • Start date Start date
H

Heidi

I have a subform which pulls up certain data to be
modified from a large table. I have a field in the large
table called dtmDateMofified. Each time a person pulls up
a record and modifies it in some way using the subform, I
need the dtmDateModified to change to the current date. I
think this needs to be done in code, but not sure what to
write and where. Can anyone help???
 
Assuming your date modifed control on the fomr is txtDateMod

In the BeforeUpdate Event of txtDateMode:

txtDateMode = date()
 
Back
Top