AutoUpdate Fields

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I am kind of new to Access. I have created an Inventory
Tracking database and have a questions. I want to have a
ModifyDate field that shows the last time a change was
made to data within the form. How can I have it update
this field with the current date automatically without the
user filling it out itself? Thank you.
 
Use the BeforeUpdate event procedure of the form to assign the current date
to the field:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.ModifyDate = Date
End Sub
 
SWEET! Thank you for the quick response!

Don

-----Original Message-----
Use the BeforeUpdate event procedure of the form to assign the current date
to the field:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.ModifyDate = Date
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top