title: How do you edit records from a VBA form that you want to interactively select?
body: <p>I have a set of ComboBox's in an MS Access 2003 DB that are all bound to fields in a single table.  However, the data that they allow you to select doesn't come from that table and instead comes from various other tables.  This works fine for the record creation story but now I want to be able to edit the record retroactively.  The problem is that I can't figure out how to refill the form elements without writing a bunch of custom code.</p>
  
  <p>My initial inclination is to provide a combo box that limits your choices to record IDs and then do a custom query and use that to set the selected values in all of different form elements.  However, I feel like I should be able to do something as simple as <code>DoCmd.GoToRecord , , , ID</code> and the form should repopulate just fine.  I'm not opposed to doing the busy work but I'm sure I'm just missing something in my relatively puny knowledge of VBA and Access.</p>