Populate Date Automatically in Access Form

[mmect]

I'm working on a very basic form and need to know how to add a current date to a field (modified_recommendation) when another field is changed (recommendation). Please let know how i can do this. Currenltly, I have the following code in my database (OnCurrent and AfterUpdate)...the problem i'm having is that the date gets populated after the records is opened + when the code's in the Afterupdate part of the recommendation field, it does work.

Private Sub recommendation_AfterUpdate()
 
    Me![recommendation_modified] = Now()
 
End Sub

[MSeda]

you just need to take the code out of the on current event. the on current event is cause the date to change before any changes are made.

[NeoPa]

MSeda's absolutely right.
I would add that, unless you do want the time element included in the field, you should use Date() instead of Now().

[mmect]

I changed the code a bit (added Date() and took the code out of On Current) and it worked great. Thanks for your help!

[NeoPa]

Very pleased to hear it :)
It's impressive how well things can work when an OP follows the instructions exactly (That's a compliment btw ;)).
Nice work MSeda for spotting the main flaw.
And nice avatar to the OP.