<div>
Form an Access Front end, you can use VBA in your form's After Insert event:<br />
<br />
Dim strSQL as string<br />
dim lngMaxID as Long<br />
lngMaxID = DMax(&quot;t1_AutoID&quot;, &quot;t1&quot;)<br />
<br />
strSQL = &quot;UPDATE T2 SET t2_new_number = &quot;&nbsp;&amp; Dlookup(&quot;t1_base_number&quot;, &quot;t1&quot;, &quot;T1_AUTOID = &quot;&nbsp; &amp;&nbsp;lngMaxID)<br />
Currentdb.execute strSQL, dbFailOnError
</div>


Form an Access Front end, you can use VBA in your form's After Insert event:

Dim strSQL as string
dim lngMaxID as Long
lngMaxID = DMax("t1_AutoID", "t1")

strSQL = "UPDATE T2 SET t2_new_number = " & Dlookup("t1_base_number", "t1", "T1_AUTOID = "  & lngMaxID)
Currentdb.execute strSQL, dbFailOnError

<div>
Hi mbizup!<br />
<br />
Thanks!<br />
Have a new situation here as well, just slightly different:<br />
<br />
<a href="https://www.experts-exchange.com/questions/22896877/Copying-a-number-to-a-table-when-adding-new-record-2.html" rel="ugc">https://www.experts-exchange.com/questions/22896877/Copying-a-number-to-a-table-when-adding-new-record-2.html</a>
</div>


Hi mbizup!

Thanks!
Have a new situation here as well, just slightly different:

https://www.experts-exchange.com/questions/22896877/Copying-a-number-to-a-table-when-adding-new-record-2.html [https://www.experts-exchange.com/questions/22896877/Copying-a-number-to-a-table-when-adding-new-record-2.html]

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Have next 2 - related - tables:<br />
<br />
t1_AUTOID (autonumber, related to t2)<br />
t1_base_number<br />
t1_etc<br />
<br />
and <br />
<br />
t2_AUTOID<br />
t1_autoid_rel &nbsp;(related one-many with t1)<br />
t2_new_number<br />
t2_etc<br />
<br />
Now, when adding a new related record to t2, I want the latest t1_base_number to be copied to t2_new_number. <br />
t1_base_number changes all the time, but when I've added a new t2-record, after that the t2_new_number shouldn't change anymore.<br />
So just copy the latest version t1 number to the t2 field. <br />
<br />
Prefable no SP... but in a view? &nbsp;VB-code in Access front-end is ok as well..
</div>
</div>


Hi,

Have next 2 - related - tables:

t1_AUTOID (autonumber, related to t2)
t1_base_number
t1_etc

and 

t2_AUTOID
t1_autoid_rel  (related one-many with t1)
t2_new_number
t2_etc

Now, when adding a new related record to t2, I want the latest t1_base_number to be copied to t2_new_number. 
t1_base_number changes all the time, but when I've added a new t2-record, after that the t2_new_number shouldn't change anymore.
So just copy the latest version t1 number to the t2 field. 

Prefable no SP... but in a view?  VB-code in Access front-end is ok as well..

Copying a number to a table when adding new record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.