ImageCombo and DataSource [Resolved]

[Tugabargains]

Hi

I need to list in a ImageCombo all entries from a RecordSet

I have the following:

...
Set cbo.DataSource = MyRs
cbo.DataField = "Designacao"
...

But with this code I only list the first entry and not all. Can you help?

Regards
Luis

[dee-u]

Could you post more code? Are you sure there are more than one record that is returned by your recordset?

[Tugabargains]

...
With MyRs
.CursorLocation = adUseServer
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "SELECT Designacao FROM CtrlTipoTerminal", Conn
End With

While Not MyRs.EOF
straux = MyRs("Designacao")
cbo.ComboItems.Add , , straux
MyRs.MoveNext
Wend
...

with this code I can list all entries (at the moment 10) but if I use the following code it only lists the first one

With MyRs
.CursorLocation = adUseServer
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "SELECT Designacao FROM CtrlTipoTerminal", Conn
End With

Set cbo.DataSource = MyRs
cbo.DataField = "Designacao"

[Tugabargains]

Any ideas why this happens?

Regards

[Raj_K_kohli]

use + sign while filling the combo
like
rs!rollno + rs!name

[dee-u]

If your code at the upper part works then why use the bottom part? Databound controls have their disadvantages too. Take a look at my sig.

[Tugabargains]

Thank you. Now I am just curious to find out why does not work.
What problems can I find with databound?

[dee-u]

In the "Data Binding is Evil" link in my signature.