OnChange from Combo box

[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

 

[Arvin Meyer [MVP]]

Use the AfterUpdate event instead of the Change event. The change event
fires with each character typed.

 

[John W. Vinson]

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?

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.

 

[Hugh self taught]

Thanks both of you. I copied my code over & it works fine