Now W.T.F is happening?

[sebs]

Hello,

Since i upsize my Access DB to SQL, i'm having a weird problem
with my app!

at one point you can view all record for one client, it show
an amount,date,notes and description.

i have to different but very similar, CO(Change orders) and
payment!

they both have the same coding exept name changes,
but now for some reason, on my payment one the amount
does'nt show in my list!

here's my codeing

Sub fillLst()
    Dim x As Integer
    lstCO.ListItems.Clear
    strSQl = "SELECT * FROM tblCO WHERE coClientId=" & frmMain.lstClients.SelectedItem
    Set rs = conn.Execute(strSQl)
    If Not rs.EOF Then
        retData = rs.GetRows()
        fraCO.Caption = UBound(retData, 2) + 1 & " Records"
        For x = 0 To UBound(retData, 2)
            Set newitem = lstCO.ListItems.Add(Text:=retData(0, x))
                If Trim(retData(3, x)) = "" Or IsNull(retData(3, x)) Then
                    newitem.SubItems(1) = retData(3, x)
                Else
                    newitem.SubItems(1) = FormatCurrency(retData(3, x), 2, vbUseDefault, vbFalse)
                End If
                newitem.SubItems(2) = retData(4, x) & ""
                newitem.SubItems(3) = retData(2, x) & ""
        Next
        cmdEditCO.Enabled = True
        cmdDeleteCO.Enabled = True
        cmdPrintCO.Enabled = True
    Else
        cmdEditCO.Enabled = False
        cmdDeleteCO.Enabled = False
        cmdPrintCO.Enabled = False
    End If
    Set rs = Nothing
End Sub

if i do a F8, retData(3, x) is always empty, when it should'nt!
but if i do msgbox rs("coPrice") just before retData = rs.GetRows(),
i see the amount, or if i do rs.requery before retData = rs.GetRows(), i see all the amount but not the notes!!!!

that is friggin weird, what happening!