updating

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

I want to loop through a recordset, and update one field at the then-current
record to a new value.
how to do?

thx.
 
Bill said:
I want to loop through a recordset, and update one field at the
then-current record to a new value.
how to do?

thx.
Click to expand...

Any reason you don't just use an Update Query? Performing updates by
looping a recordset is a LOT slower than a query in almost all cases.
 
I did find a solution, but the reason was that I needed to update a field to
a different value for each record depending on some other criteria (like the
new value would contain a random number), and I couldnt' come up with a
query that would let me do that.
 
Back
Top