When you "Set" a temp var, you are setting one variable. When you are referencing it, you are accessing the "TempVars" collection.

ex: Set TempVar("MyVar") = something -- you are specifically referencing that var.
MyField = TempVars("MyVar") -- you are setting the value of a field to one member of the tempvars collection

I couldn't have said it better myself. Oddly enough, this is only in macros. When you get to VBA, you always use TempVars.

Thank you both very much.  There is so much to learn.