Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

Access Tip: Multi-Field Search Form
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4/27/2011 4:32:49 PM
One of the most requested questions I get asked is how to create a multi-field search form in Access. Well, I put together a short 10-minute free video for the ACCESS TIPS section on how to do this.

This is only a TEENY, TINY preview of what's to come in the Search Form Seminar I'm preparing, which will be released after the SQL Seminar parts 2 and 3. There's SO MUCH more you can do with search forms in Access... but this will get you started.

Permanent Link
Keywords: search form like wildcard access tips

ALike Comment from Bernard Goah @ 3/14/2013
Thanks a million, Mr. Rost! Now, I can enter Like freely.
Show Just This Thread        Post Reply
ALike Comment from Bernard Goah @ 3/14/2013
"ALike"  keeps appearing.  I just want to type "Like". Someone please make it stop. I am using MS Access 2007.

Reply from Richard Rost:

You may have ANSI 92 compatibility mode on. Go to File > Access Options > Object Designers > Query Design > and make sure the checkboxes are OFF under SQL Server Compatible Syntax (ANSI 92).
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Brad Y. @ 5/15/2012
I got the search form working really easily.  Thanks!  

My only problem is that I can only run the search once, then I have to close the query.  Once I close the query I can then run a new search from the form.

On your video you didn't have to do this.  You just continued to ajusted the filters and click Run Query.

How did you do this?

Thank you much.

Reply from Richard Rost:

I'm pretty sure I was closing the query in the video each time, I just didn't specify it. You don't see me click on the close button because it's out of the video frame. If you don't want to have to do this, use a FORM based on that query, and you could just issue a Formname.REQUERY command which would refresh it.

Show Just This Thread        Post Reply
I found it Comment from zaher @ 4/1/2012
Hi Richard
after i sent the last thread  I found my mistake: I wrote with one criteria field "=forms" expression, but when I delete these criteria the form work very well, but I think we have to refresh query after we click run query button to work. So can we make the button do the two functions (run query and refresh it)? and how can i add (=forms) expression without any proplems?
Thank you again for your hard work
Show Just This Thread        Post Reply
working just one time Comment from zaher @ 3/31/2012
hi and thanks for thise great video, i try the with my data and worked very nice, but for one time, then it stopped to work, and i try to make another one but does't work at all, so what's the problem?
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Josef Stirnimann @ 2/28/2012
Hello, I enjoyed your 10 minute video of the access search form.
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Tandin Phuntsho @ 6/14/2011
Dear all,
i know that working with access is very effective and very helpful but i have a problem in creating a search form in access and in importing data from excel to access, so please help me.

with regards

Reply from Richard Rost:

Creating a search form will be the topic of an upcoming seminar. Importing data from Excel to Access is covered in Access 308.
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Farman Ullah Khan @ 5/16/2011
please in want to learn in access 2000 in form all tool box commands.

can this is possible?
i am trying every day but i am not clear in this tool box.

Reply from Richard Rost:

The tool box contains all of the objects that you place on your forms. I cover all of them in quite detail in my tutorials.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 8+7:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

3/30/2020Access DateDiff Function
3/23/2020Browsing and Selecting Files
3/14/2020New Access Group
3/6/2020NEW Access 2019 for Beginners
8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Richard Rost Microsoft MVP