auto populate the date field when status is closed

I have ms access table and form with fields created, user name, ticket number, status, resolved date.
Resolved date will be empty till the status is changed to "closed".
I wan the resolved date automatically filled with the current date when the status is changed to closed.
Vinakaya Chandu BabuAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PatHartmanCommented:
In the AfterUpdate event of the status field:

If Me.Status = "closed" Then
    Me.ResolvedDate = Date()
Else
    Me.ResolvedDate = Null
End if
0
All Courses

From novice to tech pro — start learning today.