capturing network user name on After Update

[Jason]

I have a form that I have capured the user name via a
module. On the add new record button i copy the user name
to a created by field. I also would like to duplicate
this when the record is altered, except in a "updated by"
field.

Just trying to keep up with who is creating records and
who is changing records.

Please email me if you can help.

Many Thanks!!!!!!

 

[Dennis Schmidt]

Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following article should resolve your questions about retrieving the
user name:

How to Retrieve Workgroup Information Under Win32
http://support.microsoft.com/default.aspx?scid=kb;en-us;210088


I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[John Spencer (MVP)]

Use the same code in the Before Update event of the form. But, assign the user
name to the Update by field/control.