Access 2007: Main form with subforms - after adding item to Combo box on Main Form, subforms do not refresh (?)
Posted on 2008-10-26
I have a main form with 4 subforms. The main form has a combo box that you choose a value and the subforms work fine. To add to the combo box, I have a command button that opens a popup form to add an item to. I close the form and the new item is in the combo box.
However, when I choose the NEW item from the combo box, the subforms do not update - or go to new blank records. If I choose one of the previous items from the combo box and hit [F5] to refresh it then works when I choose the new item from the combo. How and where do i put code to make the form/subforms refresh for the new item in the combo box.