I have code that must execute when the value of a combo box field is entered for a new record. I also want to assign a default value to this field. Unfortunately, the afterUpdate event does not occur if the default value is used; it only occurs if the user selects a value.
I tried removing the default value, and then writing some code that assigns the value in the box's gotFocus event. The afterUpdate event still isn't triggered--even though the combo box is definitely getting focus (i.e., the VBA code is successfully entering the default value into the box).
How can I, essentially, assign a default value for a field, for new records, but also have the afterUpdate event occur regardless of whether the user selects a value or the default value is used?