How do i create a form to search an access table by person first name and/or last name, random keyword search for any related, phone number..

ShotgunGaper used Ask the Experts™
I have a small client database where id like to have a form with form search fields below that brings a list of search results.

- Search Name (Searches first name, last name or part of name returning ph, email , comapny name results)
- Search Keyword ( Any part of a name or phone number that brings up any related results)
-  Reverse Phone Lookup (Can search by part of phone number or full number returning results of first name, last name, company, email.)

I have yet to setup any queries yet...Just have main contacts table with lookup to company name. thanks

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Take a look at this sample Search Form of Allen Browne.
That might give you some good ideas on how to accomplish that.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
You have asked for a lot here.

These questions have been answered many times.

You can search here for the keywords:
    Microsoft Access Wildcard Search

This should get you started as well

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial