0

I'm setting up a Data Update Form for my Access table for records to be updated. I just included a Last modified Date and Time fields, however, I was wondering was there anyway I could capture the user who was doing the update? Thanks

Ethan
  • 173
  • 12
kazzi
  • 524
  • 9
  • 33
  • You can use ^ this function e.g. as default value for the username field. – Andre Apr 27 '18 at 18:04
  • You can't use a user-defined function for a Table's Field DefaultValue property - however if you're populating the table using a Form - as in Add Mode - you can set the DefaultValue property of the control to be your function. Something like `Environ$("Username")` – dbmitch Apr 27 '18 at 18:04

1 Answers1

1

When I do this, i typically keep a variable in the event in the 'save changes' button. This variable is set to 'Environ(Username)' upon clicking, or 'CurrentUser' (if you are using mdb and are using Access Security methods). You can also keep a method in the 'BeforeChanges' event of the form your editing, and send this information to an Audit Log table as well.

Destin Consulting
  • 86
  • 5