I am getting an error when I try to use a recordset to sort another. ADODB 800a0bcd

Which says, I don't have a current record. I see that I have records displaying in both recordsets that I set up when I run a test.

I have rsPersonnel which uses 2 tables, primary ID is PersID, it also queries for DocID.
I have rsPersonnelDoc which has multiple tables. I use var1 with a WHERE tblDoc.DocID in (var1) and a run time value of (rsPersonnel.Fields.Item("DocID".Value)

Now, I think it is my logic (I don't have any) rather than a missing record. Could someone take a look at this and let me know what ya think? I really appreciate any help...
Thanks!
<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> Sad Va...

I do this sometimes but a neat way of filtering a recordset on a recordset is using queries within access itself. OEASTWICK explains this very well in his tutorial on building a search and results page. Visit www.tdsf.co.uk/tdsfdemo . If that doesn't answer your question, post your code and we'll have a look.

Did you search the microsoft knowledgebase for an answer. It is always a good place if you are stuck with error codes like ADODB 800a0bcd.

Regards,




_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Edited by - beano on 10 Jun 2002 22:28:55

Edited by - beano on 10 Jun 2002 22:29:46