Hi Bryan. You don't give us enough detail on how your data is structured to give you full feedback on what you ask. I'd reckon that at minimum you should have 1-many relationships between at least four separate tables: dept and task, task and checklist, checklist and items to check, for example, with additional linking tables to resolve dept-checked-by relationships and so on. Without knowing how you've set up your records how can we advise you?
Anyway, if you need to record the time at which you tick a checkbox you will need a date/time field for each item you want to track the time of, updated using the AfterUpdate event of the checkbox on your userform to the value of the current time - which is available by using the Now() function. Say your checkbox is called item1_check, and you have your date/time field represented by a textbox called item1_time, then in the AfterUpdate event of the item1_check control you would have event code like this:
- Private Sub item1_check_AfterUpdate ()
-
If Me!Item1_Check then
-
item1_time = now()
-
else
-
item1_time = null 'clear the time if the checkbox is unticked
-
end if
-
End Sub
This is only an example of one approach you might take. Without knowing more about your application I can't give more of an insight than this at present.
-Stewart