use network logon to fill in modified by field

[gregp94105]

I want to show who and when a record is updated. I can get the username
credentials from the environment but can't figure out how to get it into the
record field.

 

[Tom van Stiphout]

On Mon, 25 Aug 2008 15:49:07 -0700, gregp94105

One common way to do this is to have a hidden text field on your form,
bound to the WhoUpdated field. Then in the Form_BeforeUpdate event
write:
WhoUpdated.Value = MyFunctionToGetNameFromEnvironment()

-Tom.
Microsoft Access MVP