"Chris2" wrote in message
...
snip
Does an empty ADO recordset really display *both* BOF and EOF at the
same time?
Yes.
Public Sub BofAndEof()
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
With rst
.ActiveConnection = CurrentProject.Connection
.Source = "SELECT * FROM Categories WHERE False"
.Open
Debug.Print "BOF: " & .BOF
Debug.Print "EOF: " & .EOF
.Close
End With
End Sub
In the Immediate window ...
bofandeof
BOF: True
EOF: True
--
Brendan Reynolds (MVP)
|