capture username() on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
babs said:
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
Click to expand...

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


Keith.
 
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
 
Back
Top