Hi, I'm wondering how enable or disable (gray-out) combobox A depending on B combobox value choice.
Should I use some A combo after_update VBO code? Could you please give me any example showing how to solve this issue? : ) Thanks!
Hi, I'm wondering how enable or disable (gray-out) combobox A depending on B combobox value choice.
Should I use some A combo after_update VBO code? Could you please give me any example showing how to solve this issue? : ) Thanks!
In the AfterUpdate event procedure of combobox B, add If ..... then Me!comboboxA.Enabled=False - also there is Locked=True.
Thank you. It's working well however when it comes to a "tabular" form (form rows count = elements count) another problem occured.
If I have, for example three elements in my table (in form as well), then changing B-value in any of those three leads to enable/grey-out fields for all of them.
Please help, thanks so much! : )
Use conditional formatting instead. Go to comboboxA, select conditional formatting, new rule, expression is, comboboxB="x", then click on the enabled button
Great! Works just fine. Thanks : )
Last question - is there any way to not only grey out and disable a combobox but also set it's value to, for example, Null?
That is a data issue, not a "looks" issue, and can be done in VBA after the correct event such as post #2.
Thanks, I solved "data" issue by changing VBA code.