title: Return multiple items in access using Dlookup
body: <p>DealID is set using a Combobox and it needs to Display up to 3 MID's in the field below it</p>
  
  <pre><code>Private Sub DealID_AfterUpdate()
  Dim strFilter As String
  strFilter = "DealID = " &amp; Me!DealID
  Me!MID = DLookup("MID", "DealContent", strFilter)
  Exit_ProductID_AfterUpdate:
  Exit Sub
  End Sub
  </code></pre>
  
  <p>That's the code I'm using the obvious limitation is Dlookup only returns the first result it finds.
  That creates 2 problems but Ill focus on the first, It won't display more than one MID</p>
  
  <p>so how I can get the 1-3 MIDs to be displayed?</p>
  
  <p>The second issue I have is more in-depth but if anyone wants to help, a personal chat would be appreciated. Basically The form above is a child form and I need it to save a separate entry in the forms table for each Mount ID.</p>
  
  <p>If anyone would like to help but doesn't understand(as is often the case with my submissions), I think screen sharing on Skype is the best option.</p>