After Update If

[The Joker via AccessMonster.com]

Hello All,

I have a combo box on a form (frmTaskDetails) that has the status of the
current task open and a second field that has Completed Date. I'm looking to
have the Completed Date automatically populate with Date() if the user choose
Completed in the Status combo box. How would I go about doing this? My
thought was in the After Update but everything I'm trying is not working. I'm
trying to avoid validation rules if possible since it seems you can't control
the message it pops up with.

Thank you!

 

[Linq Adams via AccessMonster.com]

Private Sub StatusCombobox_AfterUpdate()
If StatusCombobox = "Completed" Then
Me.CompletedDate = Date
End If
End Sub

Replacing names as appropriate, of course.