This is pissing me off (AffectedRows)

[sebs]

Why would the recordset not return the number of rows affected, I have example in a book that show a select returning the number of rows selected !!

Public Function RunQuery(ByRef QueryString)
    Dim AffectedRows
        
    Set rs = conn.Execute("SELECT * FROM ve_forms ORDER BY title ASC" , AffectedRows, adCmdText)
        
    RunQuery = AffectedRows
End Function

Selecting for now in a MS Access database and I tested my queries and it does work.

Thanks