Gustav Brock
gustav at cactus.dk
Wed Aug 8 04:09:13 CDT 2012
Hi all Having opened a DAO recordset: Set rst = dbs.OpenRecordset(strSQL) often the first code line following is: rst.MoveFirst or, if the recordset can be empty: If rst.RecordCount > 0 Then rst.MoveFirst EndIf But is that really necessary? At which record could the recordset possibly be positioned if not at the first? Even a snapshot or an ODBC linked recordset will not - as far as I know - move anywhere until you tell it to do so. For ADO recordsets it is different as the recordcount can be -1 until you, for example, have done a MoveLast. /gustav