If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to refresh the list in a combo box..
I have an "unbound" combo box in an "unbound" form and the rowsource of the
combo box is based on a field on a table. I also assigned the "On NotInList" event to the combo box to open another form to add the new value to that table for the combo box rowsource. The problem is when I close the second form, the new item I just added to the second form does not show up in the drop list in the first form. How to refresh the combo box in the first form when I close the second form. thanks |
#2
|
|||
|
|||
How to refresh the list in a combo box..
After returning to the NotInList eventHandler from the
form, do you set the Response to acDataErrAdded before exiting? Hope This Helps Gerald Stanley MCSD -----Original Message----- I have an "unbound" combo box in an "unbound" form and the rowsource of the combo box is based on a field on a table. I also assigned the "On NotInList" event to the combo box to open another form to add the new value to that table for the combo box rowsource. The problem is when I close the second form, the new item I just added to the second form does not show up in the drop list in the first form. How to refresh the combo box in the first form when I close the second form. thanks . |
Thread Tools | |
Display Modes | |
|
|