How do I disable form control based on another field's input?

[JWJW]

I am very new at MS Office Applications and at posting to forums, so if I have done something wrong, please let me know so I can correct it.

My problem is: How do I make a form that disables certain controls based on another field's value?

Background: I work at furniture company and we need to send wood samples to our customers.
We send out Pine and Maple wood samples.
Sometimes the customer only wants Pine samples, while another may want both Pine and Maple, and another may want just Maple.

To keep track of who I've sent samples to and what samples I sent, I've created a database in Access 2016.

Objects: I have a Table that contains the following fields: CustomerName (short text), PreferredWoodType (drop down list), SentPine (Y/N), SentMaple (Y/N)

I have a Form for entering customer info for all the fields in the above table. So If my customer wants Pine samples, I will enter Pine that as their preferred wood type. When I select Pine from the drop-down list, I want the Maple checkbox to become inactive or disabled, so info cannot be incorrectly entered about that customer.



I believe VBA or Macro can help me with this, but I do not know where to learn the language.

Thank you very much for your consideration, and Merry Christmas.

[pbaldy]

Here's the general concept:

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

But your "sent" fields should probably be records in a related table. What happens when you add oak, or other woods? The concept is called normalization:

Fundamentals of Relational Database Design -- r937.com