Conditional Drop Boxes in Access. How do I do it?

[GoingUp]

I have a couple of drop down boxes in a row. What I want to happen is, if the first drop down box is a yes, then the other drop boxes get enabled. I want the other drop down boxes to be hidden or grayed out unless there is a yes in box one. How do I do that?

 

[boomerang]

Here are two Access forums. I know this question has been asked and answered at one or both. You should be able to find the information you need. I used to do a lot of my work in Access but never got really "good" at it.

http://www.utteraccess.com/

http://www.tek-tips.com/index.cfm