date update in form 1

[Kindi]

I have a date field in a form, and when a record is updated I wish the date field value to change to the date the record is updated. How do i do this?

Thanks
Kindi

 

[LonnieJohnson]

In the form's BeforeUpdate event you should put a line of code that sends the current date to the text box in question. It would look like such:

Private Sub Form_BeforeUpdate ()

MyField = Now()

End Sub


Hope this helps.
lonniejohnson@kawvalley.org