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
ShotgunGaper used Ask the Experts™
on
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

Comment
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.

http://allenbrowne.com/ser-62.html

HTH,
Daniel
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
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