Self Aware Yes no box

[kd4tgc]

I have a yes no box that i need to check yes if the date field of another table is used by a common user.

the fields are

callsign used as a common data type
net date the date a ham radio net was held
active yes/no box for sorting

I need to check that the callsign checked in to a net with a callsign and the autodate puts the date in net date.
next if the callsign has data then look at the dates and see if there are 2 checkins in the last 3 months. if so then autocheck the active box.

[stmoong]

Access 2010 database support data macros, somewhat similar to triggers. You can read more about it here.

If you're using earlier version (noting that you're using Access 2007 from your profile), then you will have to implement some VBA code in the form that updates the table, so that it will check the other table and do the necessary update to the check box column field.

[kd4tgc]

today i upgraded to access 2010