Update textbox if user change something

[SF]

Hi,

I have a form consist of several fields include 2 hiden fileds; Owner and
DateUpdate. Is there a way to change the DateUpdate and Owner to Now() and
Currentuser() respectively before moving to the next record if user is
editing the record?

SF

 

[Marshall Barton]

I have a form consist of several fields include 2 hiden fileds; Owner and
DateUpdate. Is there a way to change the DateUpdate and Owner to Now() and
Currentuser() respectively before moving to the next record if user is
editing the record?

Use the form's BeforeUpdate event:

Me.DateUpdate = Now
Me.Owner = Currentuser

 

[Jordan]

Unless he has Access Workgroup security setup via Access doesn't
"currentuser" just return "Admin" for everyone?

I use this to get the current logged on users name:

http://www.mvps.org/access/api/api0008.htm

Me.Owner = fOSUserName()

using the function above from MVPS.org