TimeModification in a form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has check boxes, I want to document the time the boxes are
checked. There are four boxes in my form is this possible? I have figured
out so far that I will have to add a column and set the control source to the
check box but I can't seem to get past that point....

Thanks in advance
Jennifer
 
Do a search. Look for "timestamp".

This type of question is asked and answered all the time.

Add a field for the time that each box is updated. Place code in the
checkmark's change event to put the current time in the timestampl field.

Look at previous posts if you need more detail.

Rick B
 
I have a form that has check boxes, I want to document the time the boxes are
checked. There are four boxes in my form is this possible? I have figured
out so far that I will have to add a column and set the control source to the
check box but I can't seem to get past that point....

Thanks in advance
Jennifer
Click to expand...

I'd suggest that you use VBA code in the AfterUpdate event of the
checkboxes. If you want to record in your table the time that each box
was checked, you will need to add four Date/Time fields to your table.
In the checkbox's AfterUpdate event you can then put

Private Sub chkBoxA_AfterUpdate()
Me!txtBoxATimestamp = Now
End Sub


John W. Vinson[MVP]
 
Back
Top