MS Access LoadFromText collapses object collection
<p>In my MS Access 2013 front-end database I use two separate techniques:</p>

<ul>
<li>LoadFromText to upload new or updated database objects</li>
<li>A collection to persist multiple instances of a form</li>
</ul>

<p>However when LoadFromText is used, the collection collapses. This is only an issue when first opening the database, as the typical sequence is:</p>

<ol>
<li>Validate the user</li>
<li>Re-link to back end data</li>
<li>Use LoadFromText to update any new objects</li>
<li>Open a 'dashboard' form as a new instance</li>
</ol>

<p>If there is nothing to update, LoadFromText is not called, and that's fine. But when there has been an update, the dashboard form disappears as soon as it is opened because the collection has been corrupted somehow.</p>

<p>I have read up about LoadFromText and using a collection to support multiple instances of a form, but cannot find anything that links these issues. Any help or pointers to clarify what's happening would be appreciated.</p>