Test for empty recordset?

[ctdak]

When you open a recordset, how do you test for the case where it has no
records?

 

[Ken Snell [MVP]]

If rst.EOF = True And rst.BOF = True Then
' there are no records in the recordset
End If

or


If rst.RecordCount = 0 Then
' there are no records in the recordset
End If

 

[Alex Dybenko]

if rst .eof and rst.bof then
'recordset has no records
end if

 

[ctdak]

Thanks Alex.

if rst .eof and rst.bof then
'recordset has no records
end if

 

[ctdak]

Thanks Ken.

If rst.EOF = True And rst.BOF = True Then
' there are no records in the recordset
End If

or


If rst.RecordCount = 0 Then
' there are no records in the recordset
End If