Scenario:
A user enters data into a subform and submits the form. Later, the user would like to return to the form to make a change. The change is to select a different option from the drop down field.
Problem:
When the user goes to perform this change, the drop down field is empty except for the value they already selected on previous submission.
Solution Ideas:
1. On form load, retrieve the list of options. Then, for each row, append the list of options to the drop down field. This did not work*
2. Variation to number one. This time, instead of appending the list of options, remove the value completely, add the list of options, then set the value to the value the user previously selected. Did not work*
3. Another variation. Capture all the rows, clear the entire subform, add the rows back one at a time. For each row use add() or append() to add the list of values. Did not work*
Open to any other ideas. To break this down to the most basic, I simply would like the user to have the ability to change their choice in the drop down field. An analogy would be going into Zoho CRM and selecting a state as part of the address, then later you would like to change the state, so you go into edit mode again, you click the drop down field and all of the values are listed. When you do this in Creator, all of the values are gone. Why are they gone and how do I get them back?
*Not sure if this is not working because it is not possible or because of code errors.