creating search system, if no results are found ie sql query gives no results, and therefore assign rs to empty string.....

i assigned the rs as normal to the sql query and then have a if statement, if rs.EOF then return msgbox bUT getting error saying:
"cannot use empty object or column name..."

any ideas???