<div>
Something is wrong here<br />
Normally your DSUM should end here :<br />

<pre><code class="code-1 nolinks" id="code-20-42845982-1"><span>DSum(&quot;[Qty1TotalCost]&quot;, &quot;tblBiddingVendorPrices&quot;, &quot;[EstimateID] = &quot; &amp; Forms![frmVendorBids]![txtEstimateID])</span>
</code></pre>
The AND is to perform a boolean operation while DSUM produces an arithmetic result.
</div>


SteveL13

<div>
Excellent advise. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
Getting an invalid string with this as the control source for a field on a form...<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29143218-1"><span>= DSum(&quot;[Qty1TotalCost]&quot;, &quot;tblBiddingVendorPrices&quot;, &quot;[EstimateID] = &quot; &amp; Forms![frmVendorBids]![txtEstimateID] &amp; &quot; AND [Qty1TotalCost]&quot;,&quot;tblBiddingVendorPrices&quot;,&quot;[Qty1Select]= 'X'&quot; &amp; &quot; )</span>
</code></pre>
<br />
Notes: &nbsp;Qty1Select is a text field. &nbsp; &nbsp;EstimateID is a number field.<br />
<br />
Can someone help?
</div>
</div>


Getting an invalid string with this as the control source for a field on a form...

(CODE)

Notes:  Qty1Select is a text field.    EstimateID is a number field.

Can someone help?

Invalid string with control source for a field on a 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.