I have two dropdowns, Lets say one is category dropdown and another is items drop down. The first having values like fruits and flowers. On changing of the first drop down, I am firing an event and getting items collection from database . Now I want to fill the second drop down with items dynamically (there I stuck) .
As I know we can not have any mapping between categories and items, But I can manage by hardcoding the values in macro.
All I need is , How I can push a new collection of values to the second drop down.
Thanks in advance.
I am not a expert but maybe the ResetOnRefresh could help: it is regarding refresh and drop-down lists
HOPEX Forms - Forms
ResetOnRefresh: 0x0200 (512): This flag is for drop-down lists and elements displaying a menu, and indicates that the menu or content of the list can change if the element has undergone modifications, and therefore needs to be recalculated.
I do not know if what you want to do is possible : it seems to me (but you'll have to verify it) that you will have a refresh problem (and I do not know if the "ResetOnRefresh" Jérôme told you about will solve it.
So I guess you could "easily" do what you want to do, but changing the attribute value of your category dropdown list from "Flower" to "Fruit" will not automatically change the item drop down list... You'll first have to close the property page and reopen it to see the updated dropdown list
Can you help me by suggesting the way to hide a metaattributevalue from a dropdown based on some condition in VBScript.
I mean, I have 5 values in dropdown, I want to hide 2 of them (I have their IDs) .
So that I can acheive my functionality.
Thanks in advance.
sorry, but I don't think you can hide values dynamically (at leas, I do not know how to do this).
The only way is to build your value list (as I showed you), but you'll have a refresh problem that I do not know how to manage.