Tracking When Tasks are Completed

[jmitchelldueck]

Hi,

I'm building a database to track contracts, and I want to create a way to track the process of a renewal. I want my end user to look at a form based on a query with all the process items and click a Completed? box as they complete items, but I also want to track the date they click it, so the process can be audited to see which steps are too slow, etc. I'm thinking I would do so with a Yes/No box that saves the date in my tracking query, but I'm not sure how to add this (maybe On Update).

Thanks to everyone answering my many questions!



Also, I would like it to save the date if the Yes/No box is un-clicked. I'm reading on the MS Office Help and it says to use a Default Value for it. Is there a more efficient way to go about this?

Oops, just realized I'm not able to use my Yes/No boxes in a query, since I'm getting them from a reference table. Is there an alternative to this?

[June7]

So you want to save the date for each time the yes/no field is edited? DefaultValue will not be useful for this. Use code in the checkbox Change event to set value of date field.

What do you mean yes/no fields are from reference table?