Combo Box question

[jpmillr1]

I have a troubleshooting database with two data fields in question - a STATUS field that denotes an issue as either "open" or "closed." I also have a DATE CLOSED field that tells what date the issue was closed.

Is there a way to force the STATUS field to "closed" if there is a date in the DATE CLOSED field?

Thanks!

 

[jason246day]

If Not IsNull(Date_Closed) Then
Me.Status="closed"
Else
Me.Status="open"
End If