default value and dates

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

Guest

I know how to make one of the fields in a record be the entry date -- no
problem. What I also need is a "modified date" field where if any information
is changed in the record the date of the changes is automatically entered.

Can this be done and can anyone out there tell me how to do?

Many thanks,
Kelley in Baltimore
 
You can build an event for On Close of your form to SetValue of the field to
Date() or Now().

That does not give you much information! You could have a history table
that records User, DateTime, & key field of the record changed.
 
Karl,

I will try the history table. I have never done one, but I am hoping that I
can find online some instructions. If you know of any site, please point me
in the right direction. I am a little out of my expertise, but am a quick
learner.

Kelley
 
Back
Top