drop down

running
cboTerm.Items.Add(oDR.Item("Term"))
produces the error: System.IndexOutOfRangeException

ps. the field Term is an Integer field in sql server 2000.

any ideas please?
Thanks

This would happen if oDR.Item("Term") does not exist

Hi,
yes, it does exist because this is the query that I am using...
thanks

SELECT
DISTINCT(Term)
FROM
CDS_CurveSpreadData
ORDER BY
Term

So if you use:

If Not oDR.Item("Term") Is Nothing Then
cboTerm.Items.Add(oDR.Item("Term"))
End If

then this also fails?

yes, that fails too.
the error again is: System.IndexOutOfRangeException

Thanks

Are you perhaps adding the same item twice?

problem solved. thanks