Use method recordcount. Example: if rst.recordcount <> 0 then ... where rst is recordset object.