Modified by field?

[Sol]

Do you know how I can automatically fill in who a form was modified by based on a users Access login?

Thanks much!

 

[Karl K]

Use the CurrentUser() function. That is the login name of the current user.

Lets say you have two fields:
TimeUpdated
UpdatedBy

In the Before Update for the form:
Me![TimeUpdated] = Date
Me![UpdatedBy] = CurrentUser

That should do it. Make sure you don't put this stuff in After Update or you'll get stuck in a loop.

 

[Sol]

Thanks, that did work. Do you know if there is a way to distinguish between Created By and Modified By? I need to keep track of both.

Thanks!

 

[Karl K]

Or, use a field CreatedBy with a default value (set in properties) of CurrentUser(), and don't change it.