Entering date when specific value in value list is selected
I've created a database to track technical faults and I have one field that is a Value List called Status. This value list only has two option, Open & Closed.
What I would like to do is to have another field called Date Closed and when the user selects Closed in the Status Value List it enters that days date. This way I can track when the fault was first reported and when it was fixed. Trouble is I can't work out how on Earth to do this and it's probably not helped by the fact that I'm a total newbie to databases with this being my very first one!