Can a Check Box Prevent Using Other Fields in a Form?

[tatihulot]

Hello, I am using Access 2013.



I have a simple flat-file database. My question deals with “freezing” or “locking” two fields in a form, so that they cannot be selected under certain circumstances. Please allow me to elaborate.

The first field is named Eligibility, and is a drop-down menu. The second field is Union, and is a Short Text field. I’ll be using these two fields for about 75% of the records.
But I also have a field named Exempt, which is a check box. Here’s what I want to do:

If this check box is marked, I want to prevent the Eligibility and Union fields from being used. This is to prevent anyone entering data from accidentally using these two fields for that particular record. It’s happened before and makes for a less organized reports and queries. Roughly 25% of the records will have this Exempt check box marked.

Is it possible to set up the check box to freeze/lock those two fields if it is checked? If it is possible, then what’s the easiest way to do it?

Thank you!

[pbaldy]

You can adapt this:

http://www.baldyweb.com/ConditionalVisibility.htm