Loading all options for child while retaining teh saved value
I have a 2 drop downs, "Car Make" and "Model" on an update page for "Owners". The dependent drop down is working fine... selecting Car Make populates Car Model, and the values are saved to the database.
When returning to that update page, Car Make works normally. I can select from all of the Car Makes, but the one I saved is the default. Since Model is dependent on Car Make, it doesn't load anything, so I setup the default value of Model from the recordset.
The problem is, if I selected Nissan > Maxima (for istance), when I return to the page, I can select another Make, but not another Model unless I change the Make to something else and then change it back again, in essence, retriggering the parent child script. The model, Maxima is in the dropdown all alone with no other option.
Is there a way to load all of the option for the Model field while retaining the saved value?