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

[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

 

[Wayne Morgan]

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.

 

[JulieD]

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

 

[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

 

[Wayne Morgan]

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.

 

[JulieD]

thanks for this, i'll let you know how i get on

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.

 

[JulieD]

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