title: Passing a Collection from VBA to a form
body: <p>I have a an MS Access database with nine tables.  The main form will be driven by a query linking the two main tables.  When I pull up any one record (&quot;family within a house&quot;), I have a lot of variable data to pull into the form (how many family members, names of each, other specific information) to retrieve from the other seven tables.  I created a VBA module, linked to this form, which is triggered when a record is loaded.  The code aggregates all the family member data into a Collection of &quot;person&quot; elements.  All of that works, as evidenced by the &quot;Immediate&quot; window in VBA.  The &quot;person&quot; object is defined as a Class Module with all the relevant attributes (firstname, lastname, email, is-parent/is-child, etc).</p>
  <p>Where I'm stuck:  how do I access the collection within the form, so I can start populating elements?  I haven't been able to find any documentation to do this, nor any similar questions asked/answered online.  Next step will be creating all the elements dynamically, but right now, being able to create a static element and setting the control source to (at least some component/value within) the collection would be a huge help.</p>
  <p>My VBA form module has a method, &quot;Private Sub Form_Current()&quot;, which generates the collection when the current record is changed.</p>
  <p>Thanks in advance...</p>