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