title: Access VBA how to select last added record?
body: <p>I have Access form with a subform.  The subform has a datasheet.  The main form has drop down box and button which adds records to the subform.  This all works fine (VBA code).  Now I want to highlight the most recently inserted record as if I clicked on the row header.</p>
  
  <p>How should I go about doing this?  The main form's combobox should still be set to the proper record at tpoint, so how do I highlight the subform record?</p>