CurrentUser() Macro

[Helystra]

I am trying to store the username of the last person to modify a record. I have found and implemented the CurrentUser() expression in a "before update" macro, but that only returns the value of Admin. What I really want is the network log in so that I do not need to create a separate log in table and tracking for the users of my database. Is there a different expression that I can use for this?

[pbaldy]

Options include the Environ() function and:

http://access.mvps.org/access/api/api0008.htm

[Helystra]

When I put Environ() into the macro in place of CurrentUser() I get an error message saying that it can't find the value. I'm new to Access so I have no coding experience so I'm probably missing some steps or something and will need a little more detail to make it work.

[pbaldy]

Sorry, I don't use macros. Apparently that function isn't available within one.

[Helystra]

ahhh i'm assuming you were offering a VBA solution then? I dont' really know how those work but I'm happy to learn if it gets me the results I'm after.

[pbaldy]

Here's where it goes:

http://www.baldyweb.com/FirstVBA.htm

and the code would look like:

Me.NameOfControl = Environ("username")

[Helystra]

Ok let me see if i have this right. For what I want, I would use the "before update" (rather than on click) and event procedure in the field I want the username to show up in and then type in your code between the Private Sub and End Sub lines as shown in your link...Is that right?

[Helystra]

is there a way to save that so I can use it on more than one form sort of like the way I can save a macro and use it over and over again with just a simple selection of the stored macro?