title: Access 2007 Setting Field to Selection in Dialog
body: <p>I would like to set a field to a value selected from a grid in a dialog.  I am using Access 2007.</p>
  
  <p>In WinForms I would:</p>
  
  <ul>
  <li>Create a child form
  
  <ul>
  <li>create a grid for the data</li>
  <li>add a property for the selected item</li>
  </ul></li>
  <li>In the parent form
  
  <ul>
  <li>add a button to open the form</li>
  <li>on successful dialog result get the selected item from the property</li>
  <li>update the object</li>
  <li>persist on event</li>
  </ul></li>
  <li>On parent edit
  
  <ul>
  <li>set selected value in child grid</li>
  </ul></li>
  </ul>
  
  <p>Is something like this possible in Access 2007 forms?  I have a Multiple Item form with the child records.  Can I select one and return that to the parent?  And on the other side, can I default the selected item on edit?</p>
  
  <p>How do people approach this in Access?</p>