on change event works when using a mouse not when using the keyboard

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

hi all

i've put a on change event on an unbound combo box - to requery a subform
.... it works fine if you select the item from the combo box using the mouse,
but if you type the value in or use the alt down arrow& down arrow to select
a value it doesn't work ... any ideas?

Cheers
JulieD
PS access ver. 2000
 
The Change event should fire each time you type a character into the textbox
portion of the combo box. If you are wanting an event to run when you make a
selection, try the Click event or the AfterUpdate event and see if they'll
do what you're wanting.
 
Hi Wayne

that was my understanding of the on change event - however when they type
into the combo box nothing's happening - but if they make a selection with
the mouse the code fires - which doesn't actually make any sense to me ...
i've tried the on exit event with the same result ... didn't think i could
use the afterupdate event as it's an unbound combo box so i'm not "saving"
the value

cheers
julied
 
Hi Wayne

just one other note - the access database is at work and i'm currently at
home so i'm trying to get some ideas to try tomorrow when i get back to work
... so please forgive me for not trying your suggestions before commenting on
them.

Regards
JulieD
 
No problem, I'll wait to see how it works when you get back to work. The
AfterUpdate event will fire, even for an unbound control.
 
thanks for this, i'll let you know how i get on

Wayne Morgan said:
No problem, I'll wait to see how it works when you get back to work. The
AfterUpdate event will fire, even for an unbound control.
Click to expand...
 
Hi Wayne

turns out access was corrupt on the machine .. more & more things that used
to work stopped working and i was getting all sorts of odd errors all over
the place - once i reinstalled access & compiled the database all worked
fine.

thanks for your time.

Regards
JulieD
 
Back
Top