ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   DataCombo seems locked after changing TabStrip (https://www.excelbanter.com/excel-programming/272304-datacombo-seems-locked-after-changing-tabstrip.html)

Reiner Wolff

DataCombo seems locked after changing TabStrip
 
Hi,

we're trying to install a DataCombo-Control (Mircrosoft DataListsControls
6.0(SP3)) on an Excel2000 UserForm. It is placed on a MultiPage-Control. We
have no problems with filling and displaying the DataCombo. On first use
everything is ok. But as soon as you change between the pages of the
MultiPage the DataCombo seems locked i.e. you can't edit the edit-field from
the DataCombo (you can open the pull-down, you seem to be able to select an
entry but the selected item is not displayed in the edit-field). If you move
the mouse over the edit-field the cursor shows an arrow instead of the
insertion-mark ('|').

Our system:
Win2000 SP3, Office2000, MDAC 2.7, SQL-Server2000 SP3

Our code for filling the DataCombo is the following:
Set recFahrzeuge = New ADODB.Recordset
recFahrzeuge.CursorLocation = adUseClient
recFahrzeuge.Open "Select * From tblFahrzeuge", cnn, adOpenKeyset,
adLockOptimistic
Set dummy = Me.Fahrzeug
Set dummy.RowSource = recFahrzeuge
dummy.ListField = "Fahrzeug"

Does anybody know this problem?

Any help is greatly appreciated.

Greetinx from Germany
Reiner






All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com