I have many comboboxes that use fields from lookup tables as row sources.

If the user types an entry that is not in the rowsource table, the entry is added to that table and the control source.

Everything works fine except for the display of the displayvalue after all this occurs. If I move the cursor back to the combobox and tab out of it the display is as it should be.

I test for the need to append in the valid event of the combobox.

Does anyone have an idea as to how/when to show the proper value in the combobox soon after the combobox loses focus?

Dale