<div>
Just add them to the SET clause like this:<br />
<br />

<pre><code id="code-20-38776803-1">Update tblTarget_sr INNER JOIN tblMerged_test ON tblTarget_sr.[Customer Part]=tblMerged_test.[Part No] SET tblTarget_sr[Target total time]=tblMerged_test.[total time], Field2 = abc, Field3 = XYZ, Field4 = NNN, etc..</code></pre>
</div>


Just add them to the SET clause like this:



Update tblTarget_sr INNER JOIN tblMerged_test ON tblTarget_sr.[Customer Part]=tblMerged_test.[Part No] SET tblTarget_sr[Target total time]=tblMerged_test.[total time], Field2 = abc, Field3 = XYZ, Field4 = NNN, etc..

<div>
Thanks for your prompt response.<br />
<br />
I have several field to update therefore its too long, I used _ (a space and underscore but its giving me compile error.<br />
Is there anything need to do like shift key or anything else.<br />
<br />
Thanks
</div>


Thanks for your prompt response.

I have several field to update therefore its too long, I used _ (a space and underscore but its giving me compile error.
Is there anything need to do like shift key or anything else.

Thanks

Post your Code here and I'll see if I can help out...

<div>
<div class="content wysiwyg-content">
Hi Exparts,<br />
<br />
I used the following VBA code to modify a table field:<br />
Currentdb.execute &quot;Update tblTarget_sr INNER JOIN tblMerged_test ON tblTarget_sr.[Customer Part]=tblMerged_test.[Part<wbr /> No] SET tblTarget_sr[Target total time]=tblMerged_test.[tota<wbr />l time]<br />
<br />
But I have more three fields in Update tblTarget_sr that need to modified at the same time while the above condition met.<br />
<br />
Please advise me what would be the VBA code to modify other fields.<br />
<br />
Thanks
</div>
</div>


Hi Exparts,

I used the following VBA code to modify a table field:
Currentdb.execute "Update tblTarget_sr INNER JOIN tblMerged_test ON tblTarget_sr.[Customer Part]=tblMerged_test.[Part No] SET tblTarget_sr[Target total time]=tblMerged_test.[total time]

But I have more three fields in Update tblTarget_sr that need to modified at the same time while the above condition met.

Please advise me what would be the VBA code to modify other fields.

Thanks

How to modify multiple field of an access table

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 Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.