SteveL13

<div>
You could take a look at my article :&nbsp;<a href="https://www.experts-exchange.com/articles/35613/Search-As-you-Type-for-Microsoft-Access-Combobox.html" rel="ugc">https://www.experts-exchange.com/articles/35613/Search-As-you-Type-for-Microsoft-Access-Combobox.html</a>
</div>


<div>
Dale, it isn't working. &nbsp;I copy/pasted your code into a query...<br><br>SELECT *<br>FROM tblPreglPartNumbers<br>WHERE (((Replace([PreglPartNumber],"-","")) Like Replace([Forms]![frmSearchForPartNumbers]![txtFilterBy],"-","") &amp; "*"));<br>And I'm getting...<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562017/Error-Message.jpg" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562017/Error-Message.jpg" class="fr-fic fr-dib"></a><br><br>
</div>


Error-Message.jpg

<div>
So, Steve, which of those solutions worked best for you?<br><br>@Gustav, I've started doing so much work with SQL Server over the last year that I have pretty much stopped using filters and just reassign the Recordsource as a new SQL string. &nbsp;In most cases it appears to be just as fast as doing a filter against a full recordsource.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a form where I can enter, for example, AB-3456 into a field. &nbsp;Then when I click a command button I want all records to display that match the alpha-numeric portion . &nbsp;It should return those records like AB3456-1, AB3456-2, AB3456-3, AB-3456-1, etc.<br><br>How can this be done? &nbsp;In other words ignore the hyphens and just use the alpha-numeric.
</div>
</div>



I have a form where I can enter, for example, AB-3456 into a field.  Then when I click a command button I want all records to display that match the alpha-numeric portion .  It should return those records like AB3456-1, AB3456-2, AB3456-3, AB-3456-1, etc.
How can this be done?  In other words ignore the hyphens and just use the alpha-numeric.

How search for records based on certain 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.