Pretty strightforward...

Code:
sqlstaffprofile = "SELECT * FROM staff WHERE staffid = " & staffid & ";"

objrs.Open sqlstaffprofile,objconn

if not objrs.BOF or objrs.EOF then



%>


<table width="462">
        <tr>
'SNIP SNIP SNIP

        </tr>
      </table>

<P>&nbsp;</P>

<%
else
Response.Write "No Records Found for that Staff ID"
end if

end if
%>
Instead of my message, I get

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.

?