<div>
<div class="content wysiwyg-content">
I am getting a syntax error with the line of code below. the field ClientCode is a text field eg CTR101.<br />
<br />
Any ideas where I am going wrong?<br />
<br />
newName = DMax(&quot;[GroupName]&quot;, &quot;tblTranslationContractGro<wbr />up&quot;, &quot;[ClientCode] = '&quot; &amp;&nbsp;[Forms]![frmtrad_commandes<wbr />2].ClientC<wbr />ode) &amp;&nbsp;&quot;'&quot;
</div>
</div>


I am getting a syntax error with the line of code below. the field ClientCode is a text field eg CTR101.

Any ideas where I am going wrong?

newName = DMax("[GroupName]", "tblTranslationContractGroup", "[ClientCode] = '" & [Forms]![frmtrad_commandes2].ClientCode) & "'"

dmax syntax error

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.