<div>
If I use * or % and put in the complete first name I get the listing I am looking for. But I would like to search on the first few characters.
</div>


If I use * or % and put in the complete first name I get the listing I am looking for. But I would like to search on the first few characters.

<div>
&gt;I would like to search on the first few characters.<br />
In that case you can avoid Like and use Recordset.Filter = &quot;Left(Customer, 5)=cust&quot;<br />
<br />
Replace 5 with the number of leftmost characters you want to filter by. &nbsp;
</div>


>I would like to search on the first few characters.
In that case you can avoid Like and use Recordset.Filter = "Left(Customer, 5)=cust"

Replace 5 with the number of leftmost characters you want to filter by.  

<div>
... slight correction...<br />
<br />
Recordset.Filter = &quot;Left(Customer, 5)='&quot; &amp;&nbsp;cust &amp;&nbsp;&quot;'&quot;
</div>


... slight correction...

Recordset.Filter = "Left(Customer, 5)='" & cust & "'"

<div>
You can use a combination of wildcard and fixed. &nbsp;Try this, assuming cust is 'boo', then this should give you boots, boom etc..<br />
<br />
Recordset.Filter = &quot;Customer like '&quot; &amp;&nbsp;cust &amp;&nbsp;&quot;%'&quot;<br />
<br />
Leon<br />

</div>


You can use a combination of wildcard and fixed.  Try this, assuming cust is 'boo', then this should give you boots, boom etc..

Recordset.Filter = "Customer like '" & cust & "%'"

Leon


<div>
<div class="content wysiwyg-content">
I am currently filtering a recordset with the following:<br />
----Recordset.Filter = &quot;Customer like '&quot; &amp;&nbsp;cust &amp;&nbsp;&quot;'&quot;<br />
Where cust is my variable from an InputBox.<br />
As long as I input the customers name exactly I get the desired results, however I would like be able to modify this for the filter to only match a portion of what I put in. Such as &quot;boo&quot; would return boots, boom etc..<br />
Thanks,<br />
<br />

</div>
</div>


I am currently filtering a recordset with the following:
----Recordset.Filter = "Customer like '" & cust & "'"
Where cust is my variable from an InputBox.
As long as I input the customers name exactly I get the desired results, however I would like be able to modify this for the filter to only match a portion of what I put in. Such as "boo" would return boots, boom etc..
Thanks,



&quot;Adodc1.Recordset.Filter =&quot; Help

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

&quot;Adodc1.Recordset.Filter =&quot; Help

"Adodc1.Recordset.Filter =" Help