Checking for an empty recordset

[Tony Wainwright]

I have read of a way to check for an empty recordset using BOF and EOF but
can't remember how it is done. Can anyione help me?

Dim rst as Recordset
Dim strVSQL as string

strVSQL = "..."
set rst = DBEngine(0)(0).Openrecordset(strSQL)

If rst.BOF and rst.EOF Then
...
End If

 

[Brendan Reynolds]

If rst.BOF And rst.EOF Then the recordset is empty, else it's not.