DataCombo seems locked after changing TabStrip

R

Reiner Wolff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top