• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

Search Field in Access

I have a form setup for my contacts. At the top, i have a search field. When i start typing, it will search for the first field, "Contact Name". I have three columns on my search: "Contact Name", "Address" and "Business Phone". How do i setup my search field to look all three columns. For example, if i have a contact who's name is John, his address is 123 Test Drive and his phone number is 999-999-9999, from the search field i can start typing any of those things and it will find him. Does that make sense? How do i set that up in my search field. I attached a screenshot. Thanks!
1 Solution
tols12Author Commented:
Here's what the query builder looks like for the search field. Can i just modify this?
Helen FeddemaCommented:
You might want to consider an alternate approach, one combo box per search value.  See my Fancy Filters database for an example.  Here is a link for downloading it:

And here is a screen shot of the form:

If you really MUST do what you are asking, the way I have accomplished this in the past is by creating a temporary table with one field holding contact name, phone and address data, either by concatenation, then wildcard search would find any string as entered in any part of the concatenated field.  If this approach is unfavourable, then (assuming your table has say 100 records in it), fill a field in a temporary table with data from contact name, then add data from address, then add data from phone - ending up with 300 records and then you search from this query and locate the record using the key field.  Complicated, but worked well for me in the past.
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.


Your query at the top of the form would be based upon the data from the temporary table created.
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>
IMHO, the "One combobox to rule them all" search design is over-rated.

It can just make searching more confusing for users, as they may not be sure if it is searching one field or more than one field.
If they can type 3 terms and it will search 3 fields?
Can they use Wild Cards?
If it searches with AND or OR logic.

Finally, it is just too much work (IMHO)  to design the interface...

tols12Author Commented:
Thanks for all the honesty boaq2000! I will probably just create three search fields. Thanks!!
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now