https://www.webmaster-forums.net/crss/node/1015839 en https://www.webmaster-forums.net/web-database-development/inserting-record-autonumber#comment-1093970 <p>The ColdFusion method....</p> <p>Lets call your AutoNumber Field RecordID for arguments sake.</p> <p>Write a query to get the max No. of records:</p> <p><div class="codeblock"><code>&lt;cfquery datasource=&quot;YourDSN&quot; name=&quot;MaxRecord&quot;&gt;<br />SELECT Max(RecordID) as MaxRecord<br />FROM YourTableName<br />&lt;/cfquery&gt;</code></div>'</p> <p>Now display the last record...<br /> <div class="codeblock"><code>&lt;cfoutput query=&quot;MaxRecord&gt;<br />&nbsp; #MaxRecord#<br />&lt;/cfoutput&gt;</code></div>'</p> <p>This will disply the last record ID...</p> Wed, 14 Nov 2001 23:10:10 +0000 openmind comment 1093970 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/inserting-record-autonumber#comment-1091824 <p>Access is not going to be very reliable for this, for an example check out the following link:</p> <p><a href="http://www.aspfaq.com/faq/faqShow.asp?fid=74" class="bb-url">http://www.aspfaq.com/faq/faqShow.asp?fid=74</a></p> Thu, 18 Oct 2001 14:04:24 +0000 Peter J. Boettcher comment 1091824 at https://www.webmaster-forums.net