<div>
Note:<br />
<br />
cboTextMnumber.Column(0)])<wbr /> is a text field.
</div>


Note:

cboTextMnumber.Column(0)]) is a text field.

<div>
<pre><code id="code-20-39832587-1">=DSum(&quot;ReadyQty&quot;,&quot;tblReady&quot;,&quot;TextMNumber = &quot; &amp; Forms!frmPlanted!cboTextMnumber.Column(0))</code></pre>
<br />
You don't need all the square brackets, but your syntax actually looked good. &nbsp;Double check field names
</div>


=DSum("ReadyQty","tblReady","TextMNumber = " & Forms!frmPlanted!cboTextMnumber.Column(0))


You don't need all the square brackets, but your syntax actually looked good.  Double check field names

<div>
--&gt;&gt;&gt; cboTextMnumber.Column(0)])<wbr /> is a text field.<br />
<br />
Whoops - Guy is correct. &nbsp;You need quotes.<br />
<br />
But his Char(34) should be Chr(34) &nbsp; &nbsp;-- no points please.
</div>


-->>> cboTextMnumber.Column(0)]) is a text field.

Whoops - Guy is correct.  You need quotes.

But his Char(34) should be Chr(34)    -- no points please.

<div>
<div class="content wysiwyg-content">
I'm trying to do a DSum using this control source but it isn't working. &nbsp;What would the correct syntax be?<br />
<br />
=DSum(&quot;[ReadyQty]&quot;,&quot;tblRea<wbr />dy&quot;,&quot;[Text<wbr />MNumber] = &quot;&nbsp;&amp; [Forms]![frmPlanted]![cboT<wbr />extMnumber<wbr />.Column(0)<wbr />])
</div>
</div>


I'm trying to do a DSum using this control source but it isn't working.  What would the correct syntax be?

=DSum("[ReadyQty]","tblReady","[TextMNumber] = " & [Forms]![frmPlanted]![cboTextMnumber.Column(0)])

DSum 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.