VB Code:
  1. Private Sub Command1_Click()
  2.     Dim results As ADODB.Recordset
  3.    
  4.     Set results = New ADODB.Recordset           ' Create new Recordset
  5.     If Not (results.BOF Or results.EOF) Then
  6.         MsgBox results.Fields.Count
  7.     End If
  8. End Sub

Why doesn't the above code work? It gives me an run-time error "operation not allowed when object is closed". However if I add a field to the recordset then it works. I need to create an EMPTY recordset for a function. Whats the problem here?