Combo box update event does not "fire" after changing combo box value with vba

I have an checkout form for an Item. The user can enter an item number to select an item. Once they select an item, the "after update" function fires and the "item inactive" field in the item master table is change to true. If they change the number I determine the oldvalue of the field by using comboItemSelected.oldvalue function. I re-activate the old value and make the new value inactive by using SQL statements. This works great.
However, if they do not know the item number, they can doubleclick on the item field and an item lookup form appears. On this form only active items are dispayed. Thus, the item they just selected will NOT be displayed. Also, on this form I allow the user to enter a search term such as "chair". Now they will only see items that have the word "chair" in the description. When the user doubleclicks the item they wish to select, I save the value in a public variable. The lookup form closes and the item selction form now has the focus again. Code continues in the Item Selection form. If a value is in the public variable, I replace the value in the combo box with the public variable value. All of this works great. The problem is that the update function does not run. Thus, the code does not re-activate a value that was replaced (if the user double clicked on a record that already had a value in the item field) and it does not de-activate the value that was selected from the lookup form. I have set breakpoints and the update event simply does not happen if I change the combo box value using code. Start Free Trial