change a checkbox when the date = today

[waraporn1215]

i have a check box which if checked (manually) shows a person inactive or unchecked which shows active. If they are inactive then they don't show on the report. so i would like to control the state of the check box by example entering a date for a student who will be absent tomorrow and then tomorrow they will not show upon the report!
thanks,
Billy

[jimatqsi]

A lot depends on the design of your database. Is there a different checkbox for each day? If so, when you enter that date, on a form I suppose, you can add some code to the AfterUpdate event of the textbox with the date. The code for that event can automatically set the checkbox for that date.

Or maybe you want to change your report query to examine the absent dates and avoid reporting records with the absent date = the reporting date.

There's very little information given here so we can't add a whole lot.

Jim

[Seth Schrock]

I think that you would find it easier to have your report check the Inactive Date field than to have the database check the box at a certain time. So you could have it setup so that you have a field called InactiveDate. Your report would then have the WHERE clause

WHERE InactiveDate <> Date()

[waraporn1215]

Hi Guys, I wil try to be a bit more specific.

1) there is a form with several sub forms on it (in Tabs).
type a name in the main form to pull up their sub form.
2) their sub form has a check box which is called "inactive"
their sub form also has a tab for attendance in which days of the week are assigned.
3) the report i print is a daily register, which prints anyone's name who has been assigned to be in on that day (taken from their individual sub form)
4) the register report will not show anyone who has the inactive check box ticked.
5) their sub form also has a tab called absent in which you can assign a date for when they will be absent.
6) i want them who are actually absent that particular day not to show on the report.

i hope this makes some sense as it seems a bit long winded?

Billy

[Seth Schrock]

So does "Inactive" mean that they aren't scheduled that day and "Absent" mean that they are scheduled for that day, but didn't show up?

As I understand what you are trying, it would still be easier to use an Absent or Inactive date field than it would be to change the checkbox on a certain day.