Jerry – in case you weren’t aware, anything posted to this forum is totally public, and will appear in Google searches. In other words, you might want to remove the footer with your contact info when replying via email to this forum. Or use the web interface. Then again, the cat is out of the bag.
Anyway, Dave Thompson did some further research and figured out another way to trigger this problem, which allowed me to definitely solve it. It turns out the .Code procedure is part of the problem, but not all of it.
Your Text List object is set up to directly modify the BusinessName field.
I think you wanted this to happen when you click on the Text List, but that is not the only time this happens. In particular, changing the First Name or Last Name fields will trigger a change in the Text List, and poof, your BusinessName data disappears – just as you (inadvertently) told it to!
When the data in a Text List is generated on the fly like this one is, it’s not a good idea to link it directly to a field. You should link it to a variable, and then have a button if you want to copy the value to a field. That way you’ll make sure that the data is only copied when you want it to be.
Thanks to Dave for going even more above and beyond on this than his usual above and beyond!