How can I test to see if a query is returning an empty recordset?
D Douglas J. Steele Dec 20, 2006 #2 If you're using OpenRecordset to open it, try: Set rs = db.OpenRecordset(SQL) If rs.BOF And rs.EOF Then ' It's empty Else ' It's not empty End If If you have something else in mind, please give more details.
If you're using OpenRecordset to open it, try: Set rs = db.OpenRecordset(SQL) If rs.BOF And rs.EOF Then ' It's empty Else ' It's not empty End If If you have something else in mind, please give more details.
