Access - Subform Special Combo box
I am trying to create a combo box on a subform. I want the combo box to have a set list of options to choose from and and option to add a new option to the list. Once the added option is added to the list, I want to be able to use it in other forms that access this subform.
Also, upon editing anything in the subform I want the subform to automatically refresh and update the form it pulls information from.