dmax syntax error

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) & "'"
LVL 1
ShawnAsked:
Who is Participating?
 
jerryb30Commented:
newName = DMax("[GroupName]", "tblTranslationContractGroup", "[ClientCode] = '" & [Forms]![frmtrad_commandes2].ClientCode & "'")
0
 
ShawnAuthor Commented:
wow. my bad. thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.