1. " the form design was shoddy and the fields were not properly bookmarked"
I'll say. I suspect the formfields were copied. Do not do that! Although it could be it was not you who did it. Copied formfields do NOT copy bookmarks (the names).
2. yes, it is a known problem (and a stupid one at that).
3. the suggested solution at MVPS does work for you. It just needs to be adjusted. The key is that you action against the Range.Fields(index). So...
change (for the text formfields):
oFrmFlds(pIndex).Result = oVar
to:
oFrmFlds(pIndex).Range.Fields(1).Result.Text = oVar
|