General information
Category:
Forms & Form designer
Many thanks, Ed. The this.requery in the valid event looks pretty good. The added value is highlighted but the cursor stayed in the combo. I also tried it in the lostfocus. Here, the cursor stayed in a "blank" combo. Pressing Tab brought up the highlighted entry.
Is this how it's supposed to work?
Again, Thanks. You've probably saved me many hours of digging "on my own" to figure this out.
>>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
>
>You can explicitly set Combo.Value(DisplayValue) property after you added new record in Combo.LostFocus event. It's safe to call Combo.Requery after you added new record to Combo.Rowsource
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only