<div>
In addition to Ron's correction, if your Customer ID is &nbsp;numeric, drop the single quotes that are delimiting txtIdCust &nbsp;as text:<br />
<br />

<pre><code id="code-20-38770522-1"> WhereCondition:=&quot;Mth= 'L1' And ID_CUST_SOLDTO = &quot; &amp; Me.txtIdCust </code></pre>
</div>


In addition to Ron's correction, if your Customer ID is  numeric, drop the single quotes that are delimiting txtIdCust  as text:



 WhereCondition:="Mth= 'L1' And ID_CUST_SOLDTO = " & Me.txtIdCust 

<div>
<div class="content wysiwyg-content">
I am trying to build a drill through sales form. &nbsp;<br />
When I click on a cell, I want to open another form (frmSingleMonthSales) filtered by a month number (L1, L2M L3...) and customer number.<br />
<br />
If I use the line below, the form opens with all sales from Mth L1<br />
DoCmd.OpenForm FormName:=&quot;frmSingleMonthS<wbr />ales&quot;, WhereCondition:=&quot;Mth= 'L1'&quot;<br />
<br />
If I use the line below, the form opens with all orders for the proper customer<br />
DoCmd.OpenForm FormName:=&quot;frmSingleMonthS<wbr />ales&quot;, WhereCondition:=&quot;ID_CUST_S<wbr />OLDTO = '&quot; &amp;&nbsp;Me.txtIdCust &amp;&nbsp;&quot;'&quot;<br />
<br />
When I combine the lines as below, I get a Run-Time error 13 Type mismatch<br />
DoCmd.OpenForm FormName:=&quot;frmSingleMonthS<wbr />ales&quot;, WhereCondition:=&quot;Mth= 'L1'&quot; And &quot;ID_CUST_SOLDTO = '&quot; &amp;&nbsp;Me.txtIdCust &amp;&nbsp;&quot;'&quot;<br />
<br />
If the each of the first two lines work, why won't the combined line work.<br />
<br />
Any help will be appreciated
</div>
</div>


I am trying to build a drill through sales form.  
When I click on a cell, I want to open another form (frmSingleMonthSales) filtered by a month number (L1, L2M L3...) and customer number.

If I use the line below, the form opens with all sales from Mth L1
DoCmd.OpenForm FormName:="frmSingleMonthSales", WhereCondition:="Mth= 'L1'"

If I use the line below, the form opens with all orders for the proper customer
DoCmd.OpenForm FormName:="frmSingleMonthSales", WhereCondition:="ID_CUST_SOLDTO = '" & Me.txtIdCust & "'"

When I combine the lines as below, I get a Run-Time error 13 Type mismatch
DoCmd.OpenForm FormName:="frmSingleMonthSales", WhereCondition:="Mth= 'L1'" And "ID_CUST_SOLDTO = '" & Me.txtIdCust & "'"

If the each of the first two lines work, why won't the combined line work.

Any help will be appreciated

Open Access 2010 drill through with multiple criteria

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.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.