Help with looping/dumping recordset

Hey guys,

Have a feeling I'm over-complicating this one... I just want to loop through three different recordsets and dump one field.

I have the loop so it begins at i = 7, so we start at range B7 and move down to B8, and so on until we have moved down the number of records. please let me know if I can clarify:

Please Login or Register  to view this content.

The error I get is, "Either BOF or EOF is True, or the current record has been deleted". However, there is one record for the first recordset, 5 for the 2nd and 4 for the 3rd. To note, it does successfully write the one record before kicking out the error.

Any ideas? Thanks.

Thanks for the response, Norie!

I now get the error, "Class does not support Automation or does not support expected interface" when I run this:

Please Login or Register  to view this content.

Unfortunately, there are several fields in the recordset. The only field I want is "COMMENTS" though.