Skip column in recordset

[jgelpi16]

I have a "For Each..." loop that updates all fields within the recordset. However, I want to skip one of the fields/columns when updating. How can you do this? I am sure there is a pretty simple solution but I just haven't been able to dig it up yet. Thanks in advance.

[pbaldy]

What is your code? Generally, you should be able to test for the name or leave it out of the recordset.

[jgelpi16]

That's what I'm looking for. Is there a command?

I'm essentially updating each field in the row....

'Pseudo-code...

For Each fld in rs.Fields
     If fld <> rs("MetricName") then
          'Update Field
     End If

[pbaldy]

Pseudo-code

If fld.Name <> "MetricName" Then

[jgelpi16]

That simple....Thanks!

[pbaldy]

No problemo!