I have two subforms on a main form. Both subforms have a combo box in them that lists each product id and its name and then allows for numbers to be entered into the rest of the fields. There is a command button beside each subform that opens a popup form to allow the user to add a new product not in the combo box list. My problem is that I haven't found a way to make the new product show in the subforms combo list after it has been added. I have other controls on the main form that I have requeried and that works, but I cannot get a subform to be updated. What do I do?

One very simple way would be to close the main form when the pop up opens and then re-open it when the pop up closes.