Hi all,
just come across a problem with the site I am building for the office. I have a asp page that lists a range of projects and if the user clicks on one it will take them to a page dedicated to that project with data pulled in from a view on SQL serv er 2000. From this page the user can add data related to that project however, if the project has not had any data added to it at that time this error message displays...

"Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/test-site1/Intranet/info.asp, line 123"

Which, to be honest, is expected as there is'nt any data for that particular project, the user has yet to add it so how do i get around this annoying little problem ? I am using DWMX to create the pages.

Thanks in advance,
Mitch....

Tricky ??

if objRS.eof or objRS.bof then 
    ' do this because there are no records
else
    ' do this because there is at least 1 record
end if