Problem With combo-box ***(KIND A) RESOLVED ***

[Lightning]

Whenever I fill a combo-box from a recordset (with this code):

While Not TempRS.EOF
    Combo1.AddItem TempRS.Fields("sdOmsch"), TempRS.Fields("ndCode")
    TempRS.MoveNext
Wend

ndCode = integer
sdOmsch = string

This is no problem, but whenever I (the code) try's to add the 27th item, it gives an error:

Run-time error '5':
Invalid procedure call or argument


Does anybody have a clue
Ow, yes ndCode is the primary key of that table

[Keithuk]

Are you sure there is some data in the database?

If its empty it will cause an error.

While Not TempRS.EOF
If Not IsNull(CStr(TempRS.Fields)) Then
    Combo1.AddItem TempRS.Fields("sdOmsch"), TempRS.Fields("ndCode")
End If
    TempRS.MoveNext
Wend

Not sure if I've pasted this correctly, I can't see your code but it checks to see if there is a valid entry.

[Lightning]

Well yes there is a check. (and I know for shure there is some data in), it adds data, only where the index is more as 26 it raeses the error

[leinad31]

sdOmsch or ndCode are not Null?

[Lightning]

Both are not NULL, the strange thing is that whenever I don't use the INDEX all works fine. But why can't I set the index to a higher value than 26???

[leinad31]

What's the data type of nCode in the database?

[hassa046]

Is it possible that the index value you uccurs twice?

[leinad31]

Originally posted by hassa046
Is it possible that the index value you uccurs twice?

Not if the primary key is already set at the database (No duplicates)

Have to rush cant wait for your reply, but its probably because the index for the combobox is limited. Either use another contol (data combo, data list) or convert nCode to Integer, whichever works.

[Lightning]

I kind a solved it. I don't use the index, but it still is strang