Combo Box not firing OnChange Event

  • Thread starter Thread starter KPR
  • Start date Start date
K

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
 
What are you hoping to achieve using the OnChange event? Try using the
AfterUpdate instead.
 
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
Click to expand...

Use the combo box AfterUpdate event, not the Change event.
 
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
 
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
Click to expand...

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.
 
Back
Top