Record saved more than once

[Tom Kennedy]

How do I determine if a record has been saved more than once?

I have a field called "RecordStatus" in every table. I want to display the entered user, entered date and entered time in this field. If the record has been edited after the initial entry I want to display (in addition to the entered data fields previously described) the modified user, modified date and modified time.

To get the result I want, I have compared the entered user and modified user along with the entered timestamp and the modified timestamp. Since the entered timestamp and the modified timestamp will always be different, all six fields of information show up on every entry.

Any ideas?

[Tom Kennedy]

Thanks for the file and your effort.

[Tom Kennedy]

One thing that I discovered was Get ( RecordModificationCount ).

This allows the modified information to appear only if the record has been edited and without any extra fields or code.

Example:

If (

Get ( RecordModificationCount ) ≠ 0

;

"Last Modified:" & ¶ &

" by " & RecordModifiedUserID & ¶ &

" on " & GetAsDate ( RecordModifiedTimestamp ) & ¶ &

" at " & GetAsTime ( RecordModifiedTimestamp )

)