Hi

How can I retrieve the next value from distinct using the code below?

*********************************************************
Qry = "Select distinct size from parttb Where id = '" & txtItem.List(i) & "' "
Set RawSql = New ADODB.Recordset
RawSql.CursorLocation = adUseClient
RawSql.Open Qry, S_GateDb, adOpenDynamic, adLockPessimistic

Size1 = RawSql(0)
//How to get size2 and so on
*********************************************************
Kindly enlightened me. Thanks alot