I have been looking at the same code for about an hour with no luck so even though I dont think this is a pro code I would appreciate some help...

I have nested loops - the problem I am encountering is that when the outer loop is entered once the inner loop loops the correct amount of times, once the outer loop is entered more then once the inner loop loops one additonal time...here is the code I cant seem to spot my error...

 orss.open "rg", objconn, adopenkeyset, adlockoptimistic



     do while not ors.EOF



      for I = 0 to ors("wl_quantity")

      orss.addnew

      orss.fields("rg_registry") = registryid
      orss.fields("rg_product") = ors("wl_product")

      orss.update

      next



     ors.MoveNext
    loop

Hi,

  What do u mean by

when the outer loop is entered once the inner loop loops the correct amount of times, once the outer loop is entered more then once the inner loop loops one additonal time...


The outer loop is loops thru recordset. Inner loop loops thru a value in recordset field. Whats u r actual requirement.


----------
Rajani

Hi Elladi,

Can you explain what exactly you are trying to do with this code. Then it might be helpful in understanding what is missing in that code posted here.

Cheers!

_________________________
- Vijay G
Strive for Perfection