I have a form with customer information. The information will be imported from Excel and someone will move through each record and add the provider information to it. There is a Provider table which holds the name and address. There is a combobox to choose a provider, which then displays the provider's address in a subform, and can be edited if needed. I would like to have a "Add new provider" button which opens a pop up form where the provider name and address would be added, and when they close it, it would populate what they typed over into the provider drop down on the main form and the provider address in the subform. I tried making the Add New Provider form be a subform as well, but since it is a data entry form and my main form is not, it didn't work. What is the best way to accomplish this? I just need a way for them to select the provider info that is already available in the table, be able to edit the address if needed, and have the ability to add new ones if the provider is not in there. I am not set on any particular setup, I just need it to function. I would appreciate any assistance. Thank you!