I have 2 forms in a database which I’ll call form A (based on table A) and form B (based on table B.) A field on form B is populated using a combo box ( a list of names) based on table A. If the name is missing in the combo box it needs to be added to table A but I don’t want to have the user exit form B, go into form A, enter the item and reopen form B. I used a command button to bring up a pop-up form on form B where the user can enter the name to go into table A. The newly entered name won’t show up in the combo box unless form B is closed and then reopened.
How can this be made to work without having the user exit form B? What other ways are there to do this?
Thanks, in advance, for any assistance.