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
LVL 1
frimyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You'd have to create your own filter form if you want more control over the process. There are many examples of this around the internet, but essentially you add unbound textboxes (or combos, or listboxes) to a form (normally in the Header section), and then create your filter criteria when the user click a button (or some other action). For example:

Dim searchdata As String

If Nz(Me.txSearchName, "") <> "" Then
  searchdata = "First_Name LIKE '" & Me.txSearchName & "*'"
End If

If Nz(Me.txSearchCity, "") <> "" Then
  If Len(searchdata) > 0 Then
    searchdata = searchdata & " AND "
  End If
  searchdata = searchdata & "City LIKE '" & Me.txSearchCity & "*'"
End If

<and so on>

Me.Filter = searchdata
Me.FilterOn = True

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
frimyAuthor Commented:
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
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use the Change event of your textboxes to fire your Search code.
frimyAuthor Commented:
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
frimyAuthor Commented:
It works very good with after update
I also wanted to filter as I type but it looks that's to complicated.
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.