default value and dates

[ceadsearc]

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

 

[KARL DEWEY]

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.

 

[Tim Ferguson]

You can build an event for On Close of your form

The BeforeUpdate event is probably a better choice...


Tim F

 

[ceadsearc]

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