User Name

[BRANDON99]

Hi

I would like the Windows user log on name to be recorded when the user add records to a table, is this possible?

Thanks

Brandon

 

[FancyPrairie]

If you're adding records to a table via a form, then in the BeforeUpdate event of the form, do something like this (where txtModifiedBy is a text control on the form whose control source is the field in your table)

If (Me.NewRecord) Then txtModifiedBy = environ("username&quot

 

[BRANDON99]

I,ve tried this, but it doesn't seem to work. I want to be able to get the Windows user name to automatically be entered when data is added. Can this be done? and if so how?

Thanks

Brandon

 

[hymn]

I have just done
Me!name = Environ("UserName&quot
and it works perfectly but it was done in the On Current event. With the record locked when date inputted

Hope this helps
Hymn

 

[BRANDON99]

Thanks - works now!