Populate field with username 2

[Leaner79]

Hi,
I would like help with the following.
I have a form that has a userneme field. I want this field to updated with the username of the person logged on to the PC.
This should only update if the form is in Add Mode.

Thanks

 

[PHV]

In the BeforeInsert event procedure of the form:
Me![userneme] = Environ("USERNAME")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AlexMidd]

Brilliant! I never knew about that one.

Have fun! )

Alex Middleton

 

[Leaner79]

Thanx, PHV

That piece of code works perfect.
But can i ask you another question?

I have a switchboard that i use to open my form in either add mode or edit mode..
I only want the above code to work when i am in edit mode..
If i am in add mode, then the username should be saved in a different field.

Thanx

 

[PHV]

Have a look at hte NewRecord property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Leaner79]

thanx for all the help

 

[ReluctantDataGuy]

Safer to use VBA.Environ("UserName")