OnChange from Combo box

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
 
A

Arvin Meyer [MVP]

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top