Do you know how to make options in form available only when checkbox is clicked yes?

[xelloss100]

Hello,



I have a little situation with a database I'm working on;

I have created a database with a couple of big forms (I had to divide them in tabs) many of the options have a yes/no check and some options to describe the variable in case is yes... a little bit like this made up example;

1) Car: Checkbox yes/no

A) Color:
B) Make:

I want A and B to only be available to complete when the checkbox is marked yes (I know that if not, it really doesn't matter, but I don't want to invite mistakes by having the fields available).

Does anybody know how to do this?


I also have one instance in which the options A can be multiple like

1) Car: Checkbox yes/no

A) Allowed Drivers

Since one car can have many allowed drivers, A is going to be another table that is going to be in relationship with the first one. So I may need to add a subform to the form I was working on. That's why I wanted to ask a variation of the fist question. Like before, how to make (in this case a subform) available only checkbox is checked yes.

Does anybody know how to do that?

If anybody knows, or has an alternative and/or suggestion, any advise would be welcomed...

Thanks

xelloss100

[pbaldy]

You can adapt this for both:

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

You can use the visible or enabled properties, depending on the look you want. You could also change the allow additions/edits/deletions properties of the subform.