Check box date stamp

Hi there, I have a check box in my form, which when checked means that job is
'dead' and therefore doesnt come up since i changed the record source to only
take jobs that have a false 'dead' checkbox. I wanted to also make it put the
current date into a hidden field of when that check box was ticked so that we
know when it 'died', any ideas? thanks Wk

1. Add a date/time field to the table your form is based on.
2. Add the field to your form and make it invisible.
3. Add the following code to the Click event of your checkbox:

Me.YourDateField = Date()

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"bilbo+" wrote in message
...
Hi there, I have a check box in my form, which when checked means that job
is
'dead' and therefore doesnt come up since i changed the record source to
only
take jobs that have a false 'dead' checkbox. I wanted to also make it put
the
current date into a hidden field of when that check box was ticked so that
we
know when it 'died', any ideas? thanks Wk

Use the AfterUpdate event procedure of the check box to record when it died.

Example:

Private Sub Dead_AfterUpdate()
If Me.Dead.Value Then
Me.[MyHiddenDateBox] = Now()
End If
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"bilbo+" wrote in message
...
Hi there, I have a check box in my form, which when checked means that job
is
'dead' and therefore doesnt come up since i changed the record source to
only
take jobs that have a false 'dead' checkbox. I wanted to also make it put
the
current date into a hidden field of when that check box was ticked so that
we
know when it 'died', any ideas? thanks Wk

hi there, do i put that in the code bit or just in the properties box.. is
there more code i need to put in as well... sorry im a bit of a begginner..

"Lynn Trapp" wrote:

1. Add a date/time field to the table your form is based on.
2. Add the field to your form and make it invisible.
3. Add the following code to the Click event of your checkbox:

Me.YourDateField = Date()

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"bilbo+" wrote in message
...
Hi there, I have a check box in my form, which when checked means that job
is
'dead' and therefore doesnt come up since i changed the record source to
only
take jobs that have a false 'dead' checkbox. I wanted to also make it put
the
current date into a hidden field of when that check box was ticked so that
we
know when it 'died', any ideas? thanks Wk