If edited then checkmark.

[Heathbo]

I'm looking for a simple way to automatically place a checkmark in a box if the record has been edited. I assume the easiest way to go would be by creating a field that automatically enters the modification date. From this point I can't figure out how to automatically checkmark a check box. Any help you can give is much appreciated.

[Lee Smith]

Why not just create an Audit or Field Modification file?

See Solutions & Suggestions >> Sample Files & Open Source Solutions for some samples on this, start with Bob Weaver's Yet another Audit Trail

HTH

Lee

[Heathbo]

I am new to Audit and Field Modification files. Basically what I need is, I have a layout where users can enter info for records. What I need is to be able to keep track of which records the users changed and have a script that exports all the changed records into one file and emails it to a coded email address. Does this make sense? Does this seem cluncky?

[comment]

How about:

ModificationDate > CreationDate

[Dan-A]

could you use a calculated field that holds a "timestamp" of the

last modification date & one that holds a creation date.

From that do as "comment" suggest in the previous post...compare the dates

and script your e-mail to be sent from that point on.

HTH

Dan