<div>
Great! &nbsp;Thank you so much!
</div>


<div>
<div class="content wysiwyg-content">
I am using the following SQL code to insert a new record into tblCaseNotes. &nbsp;The key to this table is CaseNotesId (autokey) . &nbsp;After I insert the record is there a way to find out what the CaseNotesId just created is? <br />
<br />
DoCmd.RunSQL &quot;INSERT INTO dbo_tblCaseNotes(ClientFil<wbr />eNo, SupportStaffLkUpID, CaseNotesDate) VALUES('&quot; &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; dblClientNo &amp;&nbsp;&quot;','&quot; &amp;&nbsp;dblSSLkUpId &amp;&nbsp;&quot;','&quot; &amp;&nbsp;strCaseNoteDate &amp;&nbsp;&quot;');&quot;
</div>
</div>


I am using the following SQL code to insert a new record into tblCaseNotes.  The key to this table is CaseNotesId (autokey) .  After I insert the record is there a way to find out what the CaseNotesId just created is? 

DoCmd.RunSQL "INSERT INTO dbo_tblCaseNotes(ClientFileNo, SupportStaffLkUpID, CaseNotesDate) VALUES('" & _
        dblClientNo & "','" & dblSSLkUpId & "','" & strCaseNoteDate & "');"

Lookup ID of Record just inserted with SQL

I am using the following SQL code to insert a new record into tblCaseNotes.  The key to this table is CaseNotesId (autokey) .  After I insert the record is there a way to find out what the CaseNotesId just created is? 

DoCmd.RunSQL &amp;quot;INSERT INTO dbo_tblCaseNotes(ClientFileNo, SupportStaffLkUpID, CaseNotesDate) VALUES(&amp;#39;&amp;quot; &amp;amp; _
        dblClientNo &amp;amp; &amp;quot;&amp;#39;,&amp;#39;&amp;quot; &amp;amp; dblSSLkUpId &amp;amp; &amp;quot;&amp;#39;,&amp;#39;&amp;quot; &amp;amp; strCaseNoteDate &amp;amp; &amp;quot;&amp;#39;);&amp;quot;

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.