AnsweredAssumed Answered

Entering date when specific value in value list is selected

Question asked by Peakoverload on May 21, 2009
Latest reply on May 21, 2009 by Orlando

Title

Entering date when specific value in value list is selected

Post

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!

 

Any Ideas?

Outcomes