I have a combobox with three preset values (New, In Progress, Closed).
I want to have VBA where if the combobox's value is changed from 'Closed' to 'In Progress', then my date field (ClosedDate) is changed to null.
Any suggestions? I don't know how to specifically make an action happened when...