<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>

Are you trying to assign the value of an Identity field to a variable or something else before you have saved the record?
For whatever reason, your app is trying to read the value of the identity field before the record has been saved, which is what generates that identity field.  In other words, no value exists for the Autonumber field until the row is saved.
I think we'd need to see more code or know more about the steps that lead up to this error to resolve it in more detail.