Let me explain you the problem. You have a categorized view, embedded on a form. The form contains some editable/computed fields which are populated/changed on some options (like a dialoglist etc) selected on the form.
The above works fine, but when you click on the expand/collapse twisties in the view, the field values are lost. Especially, if people are trying to build a Query string, it will loose its value.
Here is a simple way to overcome this problem.
Code
step1. Create a categorized view.
step2. Embed it on a form.
step3. Create an editable field(it should read a profile field value.), and also a dialoglist field(this will have the names of different views).
step4. On change of the dialoglist , you submit the form, write a web query save agent, which will save the selected option into a profile document, and reopens the same embedded view form.
step5. Goto the embedded view form design,choose formula for the embedded view, and write the following formula.
@if(<your editablefield>="view1";"view1";
<your editablefield>="view2";"view2";
<your editablefield>="view3";"view3";"view4").
step6. thats it..you have done everything needed to make this work.open your form in the browser,select a view name in the dialoglist, it submits the form,(dont save the form), updates the selection to a profile field, reopens the form, the editable field reads the profile field, and opens the respective view.
the advantages of this method are:
1).Only one form to dynamically display views.
2).View Category twistie problem can be overcome.
Hope this tip is helpful for you all.
