Combo Box not firing OnChange Event

[KPR]

Hi,

I have a Combo Box that is set to .dropdown when it gets the focus. However
if it drops down and the user uses the Up/Down arrow to choose a value an
then tabs out, the OnChange event doesn't fire. If the chooses the value with
a mouse click the OnChange fires fine. Any Ideas??

--Ken

 

[Douglas J. Steele]

What are you hoping to achieve using the OnChange event? Try using the
AfterUpdate instead.

 

[fredg]

Hi,

I have a Combo Box that is set to .dropdown when it gets the focus. However
if it drops down and the user uses the Up/Down arrow to choose a value an
then tabs out, the OnChange event doesn't fire. If the chooses the value with
a mouse click the OnChange fires fine. Any Ideas??

--Ken

Use the combo box AfterUpdate event, not the Change event.

 

[Tom van Stiphout]

On Sun, 26 Oct 2008 12:30:00 -0700, KPR

What were you going to do in the OnChange event? It is rarely used.
Check of the BeforeUpdate (for validation) or AfterUpdate event (for
doing things after a value was chosen).

-Tom.
Microsoft Access MVP

 

[KPR]

Thanks for the input. It works fine now.

What are you hoping to achieve using the OnChange event? Try using the
AfterUpdate instead.

 

[John W. Vinson]

Hi,

I have a Combo Box that is set to .dropdown when it gets the focus. However
if it drops down and the user uses the Up/Down arrow to choose a value an
then tabs out, the OnChange event doesn't fire. If the chooses the value with
a mouse click the OnChange fires fine. Any Ideas??

--Ken

The Change event isn't appropriate - use the AfterUpdate event instead. Change
fires at every keystroke as you *change the currently selected value* in the
combo, not when a new value is selected.