OnChange from Combo box

  • Thread starter Thread starter Hugh self taught
  • Start date Start date
H

Hugh self taught

Hi Brainy people,

I need to record partnership changes so I created a form that I open as a
popup using the OnChange event. However the OnChange field on my form is a
combo box & if I press a letter to jump to that section of the combo
dropdown, then the popup immediately opens. I understand why but my issue is
to only get the popup once I've made my change to the data value of the combo
box.

In essence I only want the popup if I exit the combo box & the value has
been changed.

Any suggestions on how to achieve this?

Cheers
H
 
Use the AfterUpdate event instead of the Change event. The change event
fires with each character typed.
 
Hi Brainy people,

I need to record partnership changes so I created a form that I open as a
popup using the OnChange event. However the OnChange field on my form is a
combo box & if I press a letter to jump to that section of the combo
dropdown, then the popup immediately opens. I understand why but my issue is
to only get the popup once I've made my change to the data value of the combo
box.

In essence I only want the popup if I exit the combo box & the value has
been changed.

Any suggestions on how to achieve this?
Click to expand...

Use the combo's AfterUpdate event (which fires after a selection has been
made) rather than the somewhat misleadingly-named Change event, which fires at
every keystroke.
 
Back
Top