How to trriger an event when data in DBCombo is changed?

I want to enable or disable a ListBox on the basis of a certain value of a DBCombo control. I have used mouseup and click and it works when these events are triggered but if I change it with keyboard it does not work. I have used change event but it does not work. I will be thankful for a suggestion.
khawarjawad@hotmail.com
Khawar091697Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ESICommented:
The best way is to use either a static or global flag (a boolean variable) to "lock" the control, or check it's enable property to  immediately exit the event.

Hope it helps
0
Khawar091697Author Commented:
Edited text of question
0
Khawar091697Author Commented:
This is not my requirement. I want to know that which 'single event' is triggered when we change item either by mouse or by keyboard.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ESICommented:
Try the SelChange event then
0
Khawar091697Author Commented:
But DBCombo don't have such event as SelChange? Kindly tell me some other way?
Thank You!
0
Steve GronerLead Systems EngineerCommented:
Perhaps you should check into subclassing the Combo box, capture the drop down, change, or roll up event if needed.
0
Khawar091697Author Commented:
Thank you Mr. sgroner for having a comment on my question.

Can you please explain, what does the term "subclassing the ComboBox" refer to? I cannot undrstand that.
0
Grant082997Commented:
If you are using the DBCombo that came with VB5, then you should install service pack 2.  This corrects the problem of the DBCombo_Change event not firing.

For more info, check out http://support.microsoft.com/support/kb/articles/Q171/7/98.asp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Grant082997Commented:
I was mistaken.  The correct web page for this is http://support.microsoft.com/support/kb/articles/Q171/8/04.asp

Sorry about that.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.