Automatically checking a box?

[Delta223]

Hello,



I have 3 yes/no checkbox fields. I would like the 3rd yes/no field to automatically check itself when both of the first 2 fields are checked. Is there any simple way to do this?

Thanks

[RuralGuy]

Strictly from a Normalization perspective, if the field can be calculated from other fields in in record then you do *not* need the field!

[Delta223]

The fields are setup to guide the end user through a process so the redundancy is helpful for me

[RuralGuy]

Then do your calculation in a query and not in the table. It will then always be accurate.