<div>
Scot,<br />
<br />
I was out of town and didn't get a chance to try it out.<br />
<br />
it works very good after pressing the enter key.<br />
<br />
is there a way to trigger the filter as I type a character without pressing the Enter key?<br />
Thanks
</div>


<div>
You can use the Change event of your textboxes to fire your Search code.
</div>


<div>
I m not sure what you mean.<br />
I need is, as I type it should filter the list based on the characters I already typed without pressing the Enter key.<br />
thanks
</div>


<div>
It works very good with after update<br />
I also wanted to filter as I type but it looks that's to complicated.<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hello All,<br />
Using Access 2010<br />
<br />
I have a customer list with the following info.<br />
CustomerID , Name, Adrs1, Adrs2, Phone, Eamil and Etc.<br />
<br />
is there a way to be able to filter with one Control field i.e. <br />
i should be able to enter a part of the name or part of the adrs or phone in one unbound control and the system should find it.<br />
i saw it in another program. can it be done with Access?<br />
The right click on any column works only one column at a time.<br />
Also i want to be able filter without right clicking.<br />
<br />
in short i want to make my application more user friendly.<br />
Thanks in advance
</div>
</div>


Hello All,
Using Access 2010

I have a customer list with the following info.
CustomerID , Name, Adrs1, Adrs2, Phone, Eamil and Etc.

is there a way to be able to filter with one Control field i.e. 
i should be able to enter a part of the name or part of the adrs or phone in one unbound control and the system should find it.
i saw it in another program. can it be done with Access?
The right click on any column works only one column at a time.
Also i want to be able filter without right clicking.

in short i want to make my application more user friendly.
Thanks in advance

Easy way to filter a list Acc2020

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.