Use the code below:

If rs.BOF And rs.EOF Then  ' Todo - No record found

I always forget this simple code to check empty record in ADO, now write it here to remind myself.

Search Keyword: ADO,check empty record, return empty record, No record found