• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 17
  • Last Modified:

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.
0
Vinakaya Chandu Babu
Asked:
Vinakaya Chandu Babu
  • 2
1 Solution
 
PatHartmanCommented:
In the AfterUpdate event of the status field:

If Me.Status = "closed" Then
    Me.ResolvedDate = Date()
Else
    Me.ResolvedDate = Null
End if
0
 
PatHartmanCommented:
Answers question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now