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
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
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
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