<div>
<div class="content wysiwyg-content">
What is wrong with:<br />
<br />
=IIf([txtReadyQty]&gt;0,DSum(<wbr />&quot;[ShipQty]<wbr />&quot;,&quot;tblShip<wbr />mentDetail<wbr />s&quot;,&quot;[Ready<wbr />ID] = &quot;&nbsp;&amp; [Forms]![frmPlanted][subfr<wbr />mReady].Fo<wbr />rm![txtRea<wbr />dyID]),0)<br />
<br />
--Steve
</div>
</div>


What is wrong with:

=IIf([txtReadyQty]>0,DSum("[ShipQty]","tblShipmentDetails","[ReadyID] = " & [Forms]![frmPlanted][subfrmReady].Form![txtReadyID]),0)

--Steve

IIf syntax problem.

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.