title: How to add new record to subform
body: <p>I recently got help on <a href="https://stackoverflow.com/q/6795377/456532">When select value from combo, highlight that record in Access subform datasheet</a> and now I'm trying to do a related task.</p>
  
  <p>How can I make the subform give me a new row for data entry from a button on the main form?</p>
  
  <p>Tried the method found here with no luck: <a href="http://www.access-programmers.co.uk/forums/showthread.php?t=26537" rel="nofollow noreferrer">http://www.access-programmers.co.uk/forums/showthread.php?t=26537</a></p>
  
  <p>EDIT: Not sure if it matters, but the table my subform is supposed to update is a linked table to SQL Server.  </p>