<div>
Are you using Microsoft Access or SQL Server?<br />

</div>


Are you using Microsoft Access or SQL Server?


<div>
Currently I'm using MS Access, but I may be switching over to SQL in the near future. SQL is SELECT @@IDENTITY isn't it? Or something similar if I remember rightly. Right now I just need the technique to get it from Access.<br />

</div>


Currently I'm using MS Access, but I may be switching over to SQL in the near future. SQL is SELECT @@IDENTITY isn't it? Or something similar if I remember rightly. Right now I just need the technique to get it from Access.


<div>
<div class="content wysiwyg-content">
How can I retrieve the autonumber field from a record I just added, I tried the following:<br />
<br />
' created rs as a recordset and queried the database<br />
rs.addnew<br />
rs(&quot;field1&quot;) = &quot;data&quot;<br />
rs(&quot;field2&quot;) = &quot;data&quot;<br />
rs.update<br />
id = rs(&quot;autonumfield&quot;)<br />
<br />
but rs(&quot;autonumfield&quot;) does not return the value that was put into the field, however it does show up when I query the database.<br />
<br />
Thanks for any help you can provide.
</div>
</div>


How can I retrieve the autonumber field from a record I just added, I tried the following:

' created rs as a recordset and queried the database
rs.addnew
rs("field1") = "data"
rs("field2") = "data"
rs.update
id = rs("autonumfield")

but rs("autonumfield") does not return the value that was put into the field, however it does show up when I query the database.

Thanks for any help you can provide.

Retrieving an autonumber field

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.