What property criteria refreshes form without clicking out of current control box?

[Bkper087]

Using VBA, I want the form to refresh once a new selection is made in a combo box without having to click outside of the box first. What is the right property to place this under? Currently I'm using the After Update option, but again, it doesn't change until after i click outside the box. Small detail, but I think it will make for a much better user experience.

[davegri]

What's the complete VBA code in the AfterUpdate event?

[CJ_London]

the event you would normally use is the change event. However this will trigger for every change. i.e. either selecting a change from the dropdown or every time you type a character in the combo.

Another alternative is to use the mouse up event which will eliminate the use of the keyboard (but might be confusing to the user), however it is typically triggered twice, once when the arrow box is clicked and once when a selection is made, so you need code to prevent the refresh happening when not required

However in either event, since the combo has not been updated, the combo will not have taken on the value - you would need to reference the combo's .text property if your refresh makes use of the combo

So agree with davegri, need understand what the refresh actually means by seeing the afterupdate code

[Micron]

I can't agree with that. The AfterUpdate event fires after a selection is made - even if you pick the same value that is already been selected. At least it does for me.
Suggest you put msgbox "After update fired" as the first line of code, save, switch back to form view and make a selection. If there's no message, then the control might be corrupt. Or, you are using the AfterUpdate event for the form itself. That's why posting the code might be important to getting a resolution.