|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 26th, 2008, 07:30 PM
posted to microsoft.public.access
|
|||
|
|||
Combo Box not firing OnChange Event
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 
|
|
#2
October 26th, 2008, 07:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
Combo Box not firing OnChange Event
What are you hoping to achieve using the OnChange event? Try using the
AfterUpdate instead. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "KPR" wrote in message ... 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
|
|
#3
October 26th, 2008, 07:51 PM
posted to microsoft.public.access
|
|||
|
|||
|
Combo Box not firing OnChange Event
On Sun, 26 Oct 2008 12:30:00 -0700, KPR wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#4
October 26th, 2008, 07:55 PM
posted to microsoft.public.access
|
|||
|
|||
|
Combo Box not firing OnChange Event
On Sun, 26 Oct 2008 12:30:00 -0700, KPR
wrote: 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
|
|
#5
October 26th, 2008, 08:08 PM
posted to microsoft.public.access
|
|||
|
|||
|
Combo Box not firing OnChange Event
Thanks for the input. It works fine now.
"Douglas J. Steele" wrote: What are you hoping to achieve using the OnChange event? Try using the AfterUpdate instead. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "KPR" wrote in message ... 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
|
|
#6
October 26th, 2008, 08:26 PM
posted to microsoft.public.access
|
|||
|
|||
|
Combo Box not firing OnChange Event
On Sun, 26 Oct 2008 12:30:00 -0700, KPR wrote:
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. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
