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?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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
0
 
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
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use the Change event of your textboxes to fire your Search code.
0
 
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
0
 
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.