automatically have checkboxes cleared the next day?

[hiccup]

Hithere,

I am still an absolute beginner with Access, and I am currently mainly trying to see what aspects of Access I would best invest my time and effort in to get the database that I am trying to build working.

One thing I would like to achieve is this:

I already have a form where I can enter data.
In that form I would like to have different check-boxes (three of them), representing actions done that day.
Let's say each form represents a contact, and I need check-boxes for:
- Called
- E-mailed
- Visited

This is something I am now able to do. But....
I would like these check-boxes to be cleared automatically the next day.
So when the database is opened the next day, these check-boxes start unchecked.
And I would also like that as soon I check a check-box on a certain day, there is an entry for that action and date is being entered in the record of that contact, so I am able to check later on what day, what action was performed.

This is certainly way over my head right now, but some tips to help me in what area I have to learn and train my skills would be much appreciated!

 

[burrina]

Here is an example, of course adapt to your needs.

If Me.SomeDate < Date Then
Dim ctl As Control      'DeSelect All CheckBoxes.
For Each ctl In Me.Controls
    If ctl.ControlType = acCheckBox Then ctl.Value = Null
Next ctl

End If

 

[hiccup]

thnx burrina, this is a very good piece of a puzzle that I will solve someday soon ;-)