Checking too see if recordset is Empty

[Loggerhead2000]

I'm trying to find out if the recordset can back empty so that if it does I can perform certain tasks like the follow

If adorecordset.BOF or adoRecordset.EOF Then
msgBox "No matching records where found"
Else
msgbox "A matching record was found"
End If

It never gets to the "No Found" section of the if stmt. I've try a few other validation stmts but basically the same thing happen. Any help that you could give me would be great.

Thanks Timmeh

 

[HobbitK]

If both the Eof = true AND the Bof = true then
the recordset is empty
Else
Is contains something

 

[Transcend]

Change or to and

Transcend