Hello,
I would like to select a "not-scheduled" status from a combo box and have a text box auto populate today's date, however I would like it to be blank if it is "Scheduled". I have tried using the code below and it works on all statuses, I just need it to be Null for "Scheduled". Can someone help me modify?
Code:Private Sub Scheduled_DropDown_AfterUpdate() If Not IsNull(Scheduled_DropDown) Then Me.NOT_Scheduled = Date ElseIf Me.Scheduled_DropDown = "Scheduled AA'" Then Me.NOT_Scheduled = Null End If End Sub