Problem with Cascading Combo Box

[henryihunter1954]

I am working on an Order Form.
My first Combo Box has a list of Members.
The second Combo Box will display the list of Recipients that are associated with the Member that has been selected in the 1st Combo Box.
That is working correctly.

Here is the problem: Each time I move from this form but return, the result of what was entered previously is gone. I have to do the process all over again.

I placed a Save Button on the form but it is not saving the selection of the Recipient.

Thanking you in advance for your assistance.

 

[isladogs]

Unless the combos have default values they will be blanks when you return to the form

You could save the values as public variables after updating the combos then on returning to the form, set the combos to those values.
Obviously you would then need to add code to reset those values to an empty string / null when no longer required