Update textbox if user change something

S

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
 
M

Marshall Barton

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


Use the form's BeforeUpdate event:

Me.DateUpdate = Now
Me.Owner = Currentuser
 
Top