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()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Date Stamp on Form 6
Subform date/time must be greater than date/time of last record 1
Date Stamps and creating a new record 7
Notes table and IndirectDataInput / Date stamp in Memo field 3
Lookup current record with ComboBox, any changes create new record 3
Form/query calculation using field value of a previous record 3
Locate record in a subform 1
Pulling ALL records in subform into VBA drafted email 1

Back
Top