Updating a multivalue combobox in its afterupdate event
Posted on 2012-08-24
I have a multivalued combobox (myComboBox) that I need to update in its afterupdate event to add a single value to the list of selected values (restoring a value that has been unselected in error).
Writing to the current record underlying the form fails with an error 3188 , because it is locked until the afterupdate event completes.
I've tried myComboBox.undo, but that doesn't have any effect.
And I can't put the code in the beforeupdate event because myComboBox.Value isn't updated at that point.
Is there a way to redimension and then add an item to the myCombobox.Value array instead? or some other way of doing this.