- Code: Select all
'Do database connection
sql = "select this from that where this = 'whatever'"
Set RS = Conn.Execute(sql)
'Do this test
If RS.BOF And RS.EOF Then
'No records were returned
Else
'Loop through to show records
End If
By testing to see if the you are at the beginning and the end of the file you will be able to tell if no records were returned.
