Combobox-dependent show/hide controls

[focosi]

Shortly, my form has 3 checkboxes and 1 combobox. I would like chechbox to be shown only when a given value is selected in the combobox. Any code to achieve this ?


Thx

[pbaldy]

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

[focosi]

Great link Paul, thanks a ton!
and the code also works at hiding labels !

Now I have one more trouble: the same show/hide behaviour should apply to more than one value in the combobox. Since it seems to me that only a single "If" statement can be created on a given control, how can I list the values with same behaviour ??? I have tested the following without any success

If Me.ControlName = "Whatever", "Whatever 2" Then

If Me.ControlName = "Whatever"; "Whatever 2" Then

If Me.ControlName = "Whatever" Or "Whatever 2" Then

[alansidman]

You could also try to use Case Select

Look here to see how that works.

http://www.databasedev.co.uk/select-case-statement.html

http://www.techonthenet.com/access/f...anced/case.php

Alan