PLEASE HELP.

I have searched online and worked on this, but I cannot figure it out!

The database record IS THERE AND IT HAS CONTENT, IT DOES EXIST.

How to fix this error?????

COMPLETE ERROR:

ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/WEBSITE/includes/thestupidfile.asp, line 6

HERE IS LINE 6 AND THE LINES SURROUNDING IT (NOTE - each record can have 3 topics, sometimes the record has 1, sometimes 2 and sometimes 3 topics maximum assigned to it)

<% Function TopicName(item)
Dim iCount
rsTopics.MoveFirst()
iCount = (rsTopics.Fields.Item("ID").Value)
For iCount = (rsTopics.Fields.Item("ID").Value) to 1 step -1
If (item)=(rsTopics.Fields.Item("ID").Value) Then Response.Write(rsTopics.Fields.Item("Topic").Value )
End If
rsTopics.MoveNext()
Next
End Function

Function InvestigatorName(item)
Dim iCount2
For iCount2 = (rsInvestigators.Fields.Item("InvestigatorID").Val ue) to 1 step -1

THANK YOU for any suggestions you might have to resolve this.

---BuddyZ

Are you sure that the sql query you *think* your executing is actually the query your executing (read as, have you printed the statement out to the screen to verifiy it)

Are you sure that you have a result set returned to your recordset object?



--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Thanks - I got it. There was an inadvertent omission of a record in the database. I reinstated it, and everything is fine.

Thanks!

Buddy Z