Check box based on values of other check boxes?

[Michael.Reynolds1775]

Hello all,



Is there a way that I can have a box check itself if certain criteria are met?

in the image below, I'd like to have the box "fully qualified/certified?" checked only if the boxes for "AAE Screening", "Med Screening", "background check", "SOU" etc are checked.

furthermore, is there a way to check the boxes for those items so long as the expiration date is not expired?

My desired endstate is if the date expires, the box will automatically uncheck itself for that specific item, therefore unchecking the box that says fully qualified.

in advance, thanks for any input.

Mike

[June7]

An expression in checkbox ControlSource can return True or False.

=[AAE Screening] AND [Med Screening] AND [background check] AND [SOU]

However, if you want to save the calculated result (not advised), that will require code.

[Michael.Reynolds1775]

I do want to save the information, so that when I run a report, I can determine who is fully qualified as of the date of the report. Why would this not be advised?

[June7]

Saved calculated data can become 'out-of-sync' with the raw data. This value can be calculated whenever needed.