current user

[Ram]

hi guys! i'm a novice programmer. I want to add "modified
by" field in my table. But the problem is that, everytime
another user logs on, "modified by" field is being
replaced with the new user that is currently logged on.
Please help me what to do. Thank you very much!

 

[Joan Wild]

hi guys! i'm a novice programmer. I want to add "modified
by" field in my table. But the problem is that, everytime
another user logs on, "modified by" field is being
replaced with the new user that is currently logged on.

Could you explain in more detail? It sounds to me that it's doing exactly
what you want. If a record gets modified, update the modified by field with
the name of the currently logged on user.