>Could someone please tell me how I return the number of records in my ADO recordset?? The recordcount property only returns -1. I am presuming I need to choose another library or use an SQL statement to determine the number of records...If anyone has a solution I would be extremely grateful. Thanks, Paul

You can also change your CursorType. Try using a Client-Sided (cursorlocation property) Static (Cursortype property) recordset.