5 Replies Latest reply on May 21, 2009 5:01 AM by Orlando

    Entering date when specific value in value list is selected

    Peakoverload

      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?