When I check a box I would like the current date to enter in a box but, I need the da

[mickjoecjr]

We have an Access program that our maintenance department uses to enter data about their projects and we have a completion check box. We would like the date to enter in the background when the box is checked. This date would be hidden in the back so only management will see it. We need this date to stay the date the box was originally checked. They tend to enter in earlier dates and we want to verify when it was actually done. We can get the date to enter with the checkbox but, it changes everyday it is opened. I need to know if there is a way to hold that original date.

Thank you,

[Seth Schrock]

Test to see if there is a value in the date field before setting the date.

[nico5038]

You could use a tblCompleteChec ked with the fields:
PlanIdentifier,
DateTimeStamp and
StatusCheckComp lete
When the checkmark is clicked you add a record in the OnUpdate event like:

currentdb.execute "INSERT (PlanIdentifier, DateTimeStamp, StatusCheckComplete) INTO tblCompleteChecked VALUES(" & Me.PlanIdentifier & " , now(), " & Me.CheckmarkField & ")"

Thus you have a full record of the values (on and off) of the planstatus.
Finally you could add the userid of the person that entered/changed the checkmark.

Getting the idea ?

Nic;o)