error '80020009' Exception Occured

[screaming_banjo]

Hi

I'm getting this error and don't have a clue what to do about it:

Author: error '80020009'
Exception occurred.

/morrisnews.asp, line 73

Here's the code I have and line 73 is in bold:

<% DO WHILE NOT rsUserID.EOF
If rsUserID("UserID") = rsNews("userID") Then response.write rsUserID("Forename") & " " & rsUserID("surname")
rsUserID.MOVENEXT
LOOP %>

I'm trying to output the name of the author of news articles on the intranet. It's weird, I've got test data in and all aritcles have an author, some of them show and some don't and this article brings up the error. I've no idea why the error wouldn't be displayed against all of them.

Anyone got any ideas how to troubleshoot this?

Thanks!

[russell]

need to see more code, but i'd start with the guess that one of those recordset fields in your code does not exist.

show the code that opens both recordsets. also tell us the database provider