Count the recordsI hated that -1 that kept poppin up instead of showing me how many records were returned. You need to Set your recordset (first line) and THEN Open it (second line) with your connection (we used cnDZ) and use the adOpenStatic cursor.