Dynamic Dropdown cache

Hi, I currently have 3 dropdown menu's created.

Menu 1 displays area
Menu 2 displays places within that area from Menu 1
Menu 3 displays places within Menu 2

This works fine. My problem is that when the form is submitted and the user returns back to this page, menu 2 & 3 are no longer populated. Menu 1 is because it is a dynamic list.

Even though the original option selected is displayed when you return the page, nothing will happen with the other menu's because they are only generated on the onChange event.

Is there any easy way to resolve this.

Also, is there a way to keep a static value when using dynamic data. For menu 2 & 3 at the moment i have a static value of i.e "Please select" but on the onChange event the menu's are populated and the static value removed.

Any help much appreciated,

Colm

You need to add a populate List From Array and Set Selected In List behavior for the the second and third menus to the onLoad Event of the Body tag.



TO keep the initial option, In the Populate List from array behavior, set the Leave Top: option to "1". this tells it to leave the first option in the list when populating the list from the array.

[QUOTE=Jason Byrnes;13599]You need to add a populate List From Array and Set Selected In List behavior for the the second and third menus to the onLoad Event of the Body tag.

What does "onLoad Event of the Body tag". I am selcting the behaviour and applying it to the child dropdown list. I only see onClick etc. Should I be clicking on something else to apply the behaviour to?

Select the body tag in the tag selector to apply the behavior to the onLoad event.

thanks for the reply jason, i'll try that today

Jason, thanks a million. worked great.

Hi Jason, just wondering, when i 'set the selected in list' for the body onLoad, what would i set the value as, because it would have been in the array and not from the database.

The lighting bolt just gives values from the db.

Thanks

When the form is submitted, are the values stored in the database?

If so, create a recordset to retrieve them to repopulate the lists.