Can someone please tell me what is wrong with this statement? It keeps giving me "object or with variable not set":
Dim rs1 As ADODB.Recordset
Dim strSQL1 As String
Set rs1 = New ADODB.Recordset
rs1.Open strSQL1, mConn
Do Until rs1.EOF *** Fails here.
I have written this code thousands of times and never had it fail.