I have a drop down on a subform and have a button to add new instances of the drop down to the subform. The drop down contains a default value and whenever I select a new value from the drop down and then add a new instance, the new instance displays the selected value from the first drop down as opposed to the default value. How do I set the new instance value to be the default value when created?
Also, if I select a value from the new instance, the first drop down value changes to match the selected value of the new instance. How do I keep each drop down value unique? If I change the value of the new instance drop down, I don't want the first drop down value to change as well.
thanks.
