Access 2013. I have two tables - CompanyInfo & EmployeeInfo. A company can have multiple employees.
I have a form EmployeeInput where the use can PICK the EXISTING company that a new employee works for from a Combo box of CompanyNames. The user can double click the combobox if the Company doesn't exist, and the CompanyInput form will open and let the user enter all the information about this new company. I have a button on the CompanyInput form to save the record and close the form "to return to employee input". When the CompanyInput form closes, I would like for the combobox on the EmployeeInput form which PREVIOUSLY did not contain the CompanyName to now SHOW the CompanyName that was just created on the CompanyInput form, along with the address, phone number, and other information from the company that was created.
I have seen some things that looked like what I needed, but so far have not been able to get it to work.
Thanks for any and all help!