Error Linking To UserID

I have got rs6 to display the Usernames but when i try and link the username with the userID it shows this error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/viewpub.asp, line 121

set rs6 = objconn.execute ("SELECT * FROM favepub INNER JOIN members ON favepub.UserID = members.UserID WHERE PubID=" & PubID)

Pubbers: <% WHILE NOT rs6.EOF%>
<a href="viewmember.asp?UserID=<%=rs6("UserID")%>"><%=rs6("rsUser")%></a>,&nbsp;

<%rs6.MoveNext
WEND
%>