refresh results in combo box
Posted on 2014-01-01
I have a combo box on a form with a query as it recordsource, in this case addresses. The user requested a button on the form to add a new address that is not in the combo box.
Easy enough, I put on the button, took them to the form where they could add a new option. The new option was added but when They return to the form the new option doesn't show in the dropdown.
How do I refresh the combo box to pick up the just added entry.
The recordsource of the combo box is a query.
I am opening the form to add an address with the acDialog option do I return to my program right after the call.
Right now I have me.addressid.requery directly after the call to the address form.
How can this be accomplished?