This should be easy, but I have not been able to figure it out. I have created a data entry form with several fields that are foreign keys linked to primary keys in appropriate information tables. I have succesfully linked to the various table and displayed information fields (rather than key numbers) in comboboxes in the data entry form. This works perfectly to lookup and enter the proper value from the appropriate table.
If the value is not in the appropriate table, I have successfully created the ability go to a data entry form for that "appropriate table" (by right clicking the combobox and selecting "Edit List Items...") and enter the new value. Now, here is my problem; when I close the "Edit List Items.." form and return to the original data entry form, I would like to have the field, in the combbox of the original data entry form, populated by the newly entered data. This is what I think should be easy, but I have not been successful. Any help would be appreciated. Thank you.