Solved

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

Posted on 1997-11-07
9
199 Views
Last Modified: 2008-03-06
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
0
Comment
Question by:Khawar091697
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 3

Expert Comment

by:ESI
ID: 1440113
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
 

Author Comment

by:Khawar091697
ID: 1440114
Edited text of question
0
 

Author Comment

by:Khawar091697
ID: 1440115
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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 3

Expert Comment

by:ESI
ID: 1440116
Try the SelChange event then
0
 

Author Comment

by:Khawar091697
ID: 1440117
But DBCombo don't have such event as SelChange? Kindly tell me some other way?
Thank You!
0
 
LVL 1

Expert Comment

by:Steve Groner
ID: 1440118
Perhaps you should check into subclassing the Combo box, capture the drop down, change, or roll up event if needed.
0
 

Author Comment

by:Khawar091697
ID: 1440119
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
 

Accepted Solution

by:
Grant082997 earned 20 total points
ID: 1440120
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
 

Expert Comment

by:Grant082997
ID: 1440121
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question