Can you get...

[natalia]

Can you get a yes/no field to reset annualy?
So if I tick the box, is it possible for it to go back to no tick after a year?

[NoellaG]

Hi Natalia,

you can if you add an extra date/time field that is automatically filled through the function Date() when the box is ticked.
Then, each time you start the application, you can run a procedure that clears all boxes and date fields where dateTicked >= dateadd("yyyy",-1,date())

gr
NG

[natalia]

Hi,

thanks for replying.

I've added an extra date/time field but I got lost at the next bit.

I'm not very good with access, as you can tell lol, so would it be possible for you to explain it any simpler? if that's possible.

sorry! but thanks for your help.

Natalia.

[NoellaG]

Hi Natalia:

next step after creating the extra date/time field is to put it on the same form, next to the check box. Presume you name the textbox txtDateChecked, you then write an event procedure in the on click event of the check box: See the picture I included.

All you have to do then is to write an update query you launch every day tro reset the boxes that are checked more then a year ago.