<div>
Getting &quot;wrong number of arguments&quot; ??
</div>


<div>
I added to the expert solution and it worked.
</div>


I added to the expert solution and it worked.

<div>
<div class="content wysiwyg-content">
I have a calculated field on a form using:<br />
<br />
=DMax(&quot;[HBA1CChecked]&quot;,&quot;Tr<wbr />eatment&quot;,&quot;<wbr />[MemberID]<wbr /> = &quot;&nbsp;&amp; [Forms]![frmMemberMaster]!<wbr />[txtMember<wbr />ID])<br />
<br />
But I get #Error when there is no record to DMax.<br />
<br />
How can I hide the #Error &nbsp;??
</div>
</div>


I have a calculated field on a form using:

=DMax("[HBA1CChecked]","Treatment","[MemberID] = " & [Forms]![frmMemberMaster]![txtMemberID])

But I get #Error when there is no record to DMax.

How can I hide the #Error  ??

Hide #Error on form

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.