Everytime I try to do a recordcount on my open recordset, I get -1. How do I get the correct count?
This is due to the location of the cursor in ADO recordsets.<BR><BR>Try setting the cursorLocation property to adUseClient. Assuming you have the ADOVBS.inc file included.<BR><BR>HTH<BR><BR>Jerry
when do I set this? before populating a field?
Before opening the recordset...<BR><BR><BR>Set rst = CreateObject("ADODB.Recordset")<BR>rst.CursorLocat ion = adUseClient<BR>strSQL = "SELECT ..."<BR>rst.Open strSQL, connectionString ...<BR><BR><BR>HTH<BR><BR>Jerry