title: Access not going to new record
body: <p>I have an access app that is quite complicated and old, and really shouldn't be in access at all.  </p>
  
  <p>I am trying to add a new form.  I copied the old form and changed the SQL table names to the new ones. I added test data in SQL and everything looks fine. </p>
  
  <p>However I can't add new records.  The other forms have a new button that works, or you can just click on the little arrow at the bottom.  In this case it's greyed out.  </p>
  
  <p>The New button gives me error 2046 The command or action RecordsGoToNew isn't available now.  Tried both and they don't work.  </p>
  
  <pre><code>' DoCmd.GoToRecord , , acNewRec
    DoCmd.RunCommand acCmdRecordsGoToNew
  </code></pre>
  
  <p>What am I missing?  I don't use Access often and this code is so old I'm having a hard time understanding it.  There is a lot of on error resume next. So I don't think it's written well either.  But that's not the point. </p>
  
  <p>Any help would be appreciated.  Thanks. </p>
  
  <p>ETA I think this might be an SSMS issue and tagged it as such.  If I do an unlinked table it works.  What would cause that to happen?  </p>
  
  <p>Thanks.  </p>