I have a search page that is linked to the results page. Everything works right until I enter a search term that is not in the database. It gives me the following error:

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/d2/result_search_staff.asp, line 815


Now I've tried the 'Show region if recordset in not empty' but it doesn't work, it still lands me with an error.

Does anyone know how I can sort this out?