In A97 and DAO via a For Next loop I'm passing the values in a array  of
fields in a fields collection from one record set to another and finally
updating a form. How do I create an If then else statement that
processes all the fields except one field, and with that one field
ignores it like it wasn't in the collection at all?  TIA

if NOT r(i).Name = "SkipName" then
        'Process the field
else
        'don't process the field
end if

Any Help?

Jim Bailey