AutoUpdate Fields

[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.

 

[Allen Browne]

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

 

[Don]

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.




.