This is everybody wish but it is not working like this.
Combos are static controls (they are set and the show the list of items).
When you have a dynamic recordset, you need to move into your recordset to see deletions/additions and /or modfications to data. Because the combo is static, it does not browse the recordset after having been set. This is why you need to refresh it yourself.
>I have an Applicattion runing on 30 concurrent users wherein i have used Third Party ActivX Control(Combo Box) bounded to a ADODC control.
>Now what I want is, whenever one user add/modify/delete records in related table the recordset of ADODC must get reflected automatically, but it is not happening if at all I set the CursorType Property to adOpenDynamic.
>And I dont want to call Refresh method of ADODC or Requery method of Recordset because it consumes to much time which I can't allot.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com