Setting a field based upon status of another field

[CQCDave]

I' running access version 2013. I have a form with a field of NCRStatus which opens in the status of Open. When that NCRStatus is changed to Closed i want to populate the DateClosed field with current date. How am i able to do this.


Thanks for the help!

[JoeM]

You can use the AfterUpdate event of the NCRStatus field to update the DateClosed field, i.e.

Private Sub NCRStatus_AfterUpdate()

    If Me.NCRStatus = "Closed" Then
        Me.DateClosed = Date
    End If
    
End Sub

[CQCDave]

Thanks, that did it. Appreciate the help.