To keep track of the records, I have created 4 fields:

- created by

- created on

- modified by

- modified on

For "created by" I am using an Auto-Enter calculation: LeftWords(Status( CurrentGroups),1)

For "created on" and "modified on" I simply use the Auto-Enter creation date and modification date.

Now for "modified by" I don't want to use "modifier name". I would like to use the calculation like for "created by", but I don't know what triggers the "modified" status so I don't know how to test for it...

Thanks for any help you might provide!

P.S. the closest thing I found was Status (CurrentRecordModificationCount) but it is not quite what I need...

I hope this will clarify what I am trying to say:

I need to keep track of who created the record and who modified it last. I don't want to use the "user name" since it is in fact the "machine name": more than one person can be modifying the database using the PC. I want to use the password to identify the user. Each password is associated to a group. So I use the current goup to identify a user.

I can easily identify who created to record, but I have not been able to figure out how to identify who modified it last... I know how to identify the user but not if the record has just been modified by that user.

Can anyone help? Is there a function/statement that I can use that tells me "Yes this record has just been edited and modified"?