AfterUpdate: Date and User changed fields updated but then stuck.

[iowabuckmaster]

I have forgot something. I have a single table form. When record gets changed my AfterUpdate event works fine to the extent it places the values in the fields, but then I can't move off that record for nothing. I have to Edit Undo Current record. Here is my AfterUpdate Event.

Private Sub Form_AfterUpdate()

[Changed Record Date] = Now()
[Changed Record User] = NetWorkUserID()

End Sub

 

[iowabuckmaster]

I put the same code on BeforeUpdate and everything works fine. AfterUpdate was continuing to fire because the changed fields would change each time I tried to leave the record. Sorry to bother everyone. Thanks for all the help in the past.

 

[BobJacksonNCI]

iowabuckmaster,

Guess your mind froze up...not surprising as I grew up near Cedar Rapids and remember how cold it gets!

Actually, pretty cold here in New York State just now.
Around 0 with wind chill below zero. Just like when I was foolish enough to chase pheasants during my youth.

Glad you solved your problem!
Bob