guard data in form

[_Brian_]

In Access's form I need to guard a date of modification .. but only that guards when a change is done in the record?

In that event would put on this action.

 

[pafcpilgrim]

Brian,

What i would do is lock the date of modification field so knowone can change it at any point!

You could then do two things either use the form event "On Dirty" which means any editing of the data will be picked up and code can be run or place the following into the save/update button if you have one before the save operation takes place

ModificationDate.value = date()

Mike

 

[ghudson]

Take a big step forward and add an Audit Trail field to your application. Check out the audittrail.zip sample I attached in that thread.