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

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/conrad...essjunkie.html



"babs" <(E-Mail Removed)> wrote in message
news:83D120DC-CEF9-4671-BC95-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news:83D120DC-CEF9-4671-BC95-(E-Mail Removed)...
>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.

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" wrote:

> 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/conrad...essjunkie.html
>
>
>
> "babs" <(E-Mail Removed)> wrote in message
> news:83D120DC-CEF9-4671-BC95-(E-Mail Removed)...
> >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
> >
> >
>
>
>

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/conrad...essjunkie.html



"babs" <(E-Mail Removed)> wrote in message
news:C82FA6F0-5E93-4423-BDBF-(E-Mail Removed)...
> 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" wrote:
>
>> 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/conrad...essjunkie.html
>>
>>
>>
>> "babs" <(E-Mail Removed)> wrote in message
>> news:83D120DC-CEF9-4671-BC95-(E-Mail Removed)...
>> >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
>> >
>> >
>>
>>
>>