VB Forum / Database Access / February 2005

I've created an ADO recordset,at run-time, to hold VAccess configuration
settings.  I step through the values and update them after each loop.

All works well until I try to update a sort order value using a loop
statement in another function used after the initial loading of the table.

What I am trying to achive is the ability to reasign table names to a
VAccess array. eg. I have two tables. When I first load the tables into the
recordset, one table has a value of 0 and the other has a value of 1.  When
the user selects a sorting column in my lookup, the function is to loop
through this record set and replace each 0 with a 1 and each 1 with a 0.  I
then reasign the VAccess table names with VAccess(0) having the table
assigned to the table name in the record with the sort of 0.

My problem is that the loop does not stop at EOF as expected.  It loops 4
time for these two records.  Here is my code:
With rsTable
.MoveFirst
Do While Not .EOF
.Fields("IndexNumber") = IIF(.Fields("IndexNumber") = 0 ,1, 0)
.Update
.MoveNext
Loop

As you can see, this is straight forward code.  I've shut down my
workstation to be sure that something was not remaining in memory that
shouldn't be there and I still have the same problem.

If I stop my code at run-time and step through this loop and not allow it to
run past the 2 tables, the rest of my code works as expected.

Is there something that I am not seeing with regards to update, movenext
with an ado recordset? Am I breaking some rules?

I look forward to any ideas or help.

Don