title: MS Access ADP Autonumber
body: <p>I am getting the following error in an MS Access ADP when trying to add a record on a form linked to a MS SQL Server 2000 table:</p>
  
  <blockquote>
    <p>Run-time error '31004':</p>
    
    <p>The value of an (AutoNumber) field
    cannot be retrived prior to being
    saved.</p>
    
    <p>Please save the record that contains
    the (AutoNumber) field prior to
    performing this action.
    note: <em>retrieved</em> is actually spelled wrong in the error.</p>
  </blockquote>
  
  <p>Does anyone know what this means?</p>
  
  <p>I've done a web search and was only able to find the answer at a certain site that only experts have access to.</p>