Link to home
Start Free TrialLog in
Avatar of frimy
frimyFlag for United States of America

asked on

Easy way to filter a list Acc2020

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
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of frimy

ASKER

Scot,

I was out of town and didn't get a chance to try it out.

it works very good after pressing the enter key.

is there a way to trigger the filter as I type a character without pressing the Enter key?
Thanks
You can use the Change event of your textboxes to fire your Search code.
Avatar of frimy

ASKER

I m not sure what you mean.
I need is, as I type it should filter the list based on the characters I already typed without pressing the Enter key.
thanks
Avatar of frimy

ASKER

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