Update =Date() on Form Load

[ashleybyrdnc]

I have a form, that when I create a new record it puts a a =Now() time stamp in the Date Field, but I would like for that time to be updated if anything on the record is changed, later on. How do I update that time?

 

[RuralGuy]

Put your code in the form's BeforeUpdate event. Any time the record is changed the field will reflect the current DateTime of the change.

 

[ashleybyrdnc]

I think thats my problem my code isn't working!

 

[RuralGuy]

Post the BeforeUpdate SubRoutine starting at Private and go to End Sub so we can see it. Use the code tags to preserve the formatting.