capture username() on form

[babs]

I have a field calle user in a table, on the form have the user field. Would
like to tie it to an Event (Oncurrent) of form makes it look okay when

I have a field in the table called user but not sure what else to do. - not
sure what to attach it to or the exact code.

user=currentuser()

attached it to the before updat of the form - don't want the user to change
if just navigate with buttons through records and not changing data . if
data changed in record or record added want the new user captured.

didn't work on on current event of form either

thanks for helping

 

[Lynn Trapp]

Put this in the before update event of the form.

Me.User = CurrentUser()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Keith Wilby]

I have a field calle user in a table, on the form have the user field.
Would
like to tie it to an Event (Oncurrent) of form makes it look okay when

I have a field in the table called user but not sure what else to do. -
not
sure what to attach it to or the exact code.

user=currentuser()

attached it to the before updat of the form - don't want the user to
change
if just navigate with buttons through records and not changing data . if
data changed in record or record added want the new user captured.

didn't work on on current event of form either

thanks for helping

This was answered for you in microsoft.public.access.forms. Please
crosspost, not multi-post.


Keith.

 

[babs]

When I first come back into the form and Navigate forward (1 to 2) under a
different user I can see the username is set to who put the record in.(or who
looked at it last). Then when I navigate back it gets reset to the present
user. I don't want the username to change if a new person is just navigating
through the records??? Any ideas.

thanks,
Barb

 

[Lynn Trapp]

Do you also have that code in the Current event of the form?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html