Microsoft Access Multi-Field Search Form 2.0 New and Improved Features!

In this video, I'm going to teach you how to make a multi-field search form so that you can find records based on multiple criteria such as a partial first name, last name, state, and so on. We'll also see how to search for numeric values, including dates, and yes/no fields.
This video is a followup to one of my most popular KZbin videos on making a multi-field search form. The original was released in 2011 and received over 580,000 views and more than 500 comments and questions over the past 10 years. So in this video, we're going to build the Search Form bigger and better, add some new features, and answer some of the questions people posted about the original.
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a much more powerful version of this search form without using a query. We will use VBA to dynamically write the SQL statement that feeds data to the form on the fly. We will also resolve the problem of the blank values, and see how to incorporate a sort order into our form.
MEMBERS VIDEO:
• Access Search Form 2.0...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/SearchForm2
LINKS:
Original Search Form: 599cd.com/MultiFieldSearch
Blank Database Template: 599cd.com/Blank
Query Criteria: 599cd.com/Criteria
Value From Open Form: 599cd.com/FormName
Wildcard Search: 599cd.com/Wildcard
Concatenation: 599cd.com/Concat
Between: 599cd.com/Between
Intro to VBA: 599cd.com/VBA
Search Seminar: 599cd.com/SearchSeminar
SQL Seminar: 599cd.com/SQLSeminar
IIF Function: 599cd.com/IIF
AfterUpdate: 599cd.com/AfterUpdate
Evil Access Stuff: 599cd.com/Evil
Double Double Quotes: 599cd.com/Double
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, search form, requery, dynamic sql, find records, locate specific records, query criteria, search box, search criteria, go to specific record, search form multiple fields, multi field search, filter multiple fields, multiple criteria, multi field search form, advanced search form, multiple keyword search, wildcard, vba, sql, me.requery
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@petewarby7158]

Unreal. I have been looking for Something like this via google for weeks and been so confused by the"text based" learning... I needed to just see it ... What a fantastic find this video was. I'm going to go through and watch loads more. BRILLIANT. Thank you so much for your course(s)!

[@jeffallan3140]

Loving these videos. 20 years ago I did a small amount of Access work but never got proficient at it. I've spent the last 10 years working with SQL (very basic query stuff) and in searching for help on some more complex queries stumbled across this series. I never realized just how good Access is and how useful it can be. Some of the query similarities are striking as well.

[@599CD]

Yep! In fact, the people who usually hate on Access are the ones who don't know it well. "Oh, it's not a real database." Yeah! It certainly is! I've been working with Access for almost 30 years now, and not only have I made a career out of it, but it's hands-down the best FRONT-END rapid database development tool out there. Sure, SQL Server is a better back-end, but you can't beat Access for front-end design.

[@jeffallan3140]

@@599CD Very quick indeed. Just for practice I built a rudimentary asset tracking system. 3 hours in and it was deployable. Could still use some tweaks and improvements but it's not bad. I don't think I could have done that back when using Access 97.

[@NFAtoys]

This has to be one of, if not the best, Access instruction videos on the Internet. Richard, you are an Access Guru.

[@599CD]

Thanks!

[@ZahidKhan-mb6oc]

One of the greatest of your videos, I learned and enjoyed the information with your unique way of explanation. It would be guideline for decades as you said. God bless you.

[@599CD]

Haha thanks!!!

[@edwardsapu2032]

Can you create invoice that includes store goods, GST,Total and others....

[@deltapixels]

have learnt so much watching this and all your other videos. Makes it so much easier to learn and understand. Thank you Richard you're a great tutor

[@599CD]

Welcome

[@gabrielzimm1047]

Excellent video...you give clear and concise instructions while simultaneously enjoying what you do!

[@599CD]

Glad you enjoyed it!

[@nickstocker]

This was an extremely helpful video. Thanks so much for explaining everything so well.

[@599CD]

You're very welcome!

[@letitiablake7243]

Richard, Thank you for the Help. After Watching this video and the extended Member's cut. I was about to fix my issues. I have had been stuck for months and I don't know why I didn't watch them before. Thank you for the recommendations, You rock \m/ Have a wonder week.

[@599CD]

Glad it helped

[@jaredmigeta5618]

you're fantastic. you've assisted me a lot in programming course. thank you sir

[@jaredmigeta5618]

smart teaching

[@599CD]

Thanks

[@politicsamnesia9304]

That is an excellent video. It covered more than I thought it would and it has been extremely useful.

[@599CD]

Thanks

[@johnnyringo79]

Great Video Rich, you're really helping me out create a database from scratch for my company.

[@599CD]

Glad to help!

[@gregoryjeffries8475]

I want to thank you for all the work you put into creating these videos. I am nolonger in the market, basically retired, but I do have a few projects in the works for personal use. I like the versatility and flexibility of Access and prefer VBA to Macros for the same reason. I am self taught in most of the languages I have used except Fortran, which I was taught in highschool along with Physics, yes I'm a dinosaur. Again, thank you for all the wonderful videos.

[@599CD]

You're very welcome. I must be a dinosaur too because I learned FORTRAN in high school as well. They taught that and Modula-2 when I was begging them to teach something new (at the time) like C/C++. I bet my teacher that I could bring down the server within an hour or two. He laughed at me. The dummy didn't set disk quotas, so I wrote a recursive loop that filled up the hard drive with tiny random text files. I got called down to the office a few periods later. :/

[@gregoryjeffries8475]

Fortran course was "write name, address and phone number", took physics same yr and saw connection and began writing pgms in celestial mechanics, orbital velocity for earth, moon and other planets. Took courses in reverse order, computer science and data processing the following year. In dp had to make flow chart for "driving down road and have flat, flowchart change tire, most turned one or two pages in, I had 8 or 9, don't remember now. Instructor held up my papers and announced to class "this is is how you write a flowchart". Condition chks for weather, lanes, tools , tire, etc.

[@sarahbliss1330]

What a super video! Thank you, very helpful!

[@599CD]

Welcome

[@luzkrg]

Mindblown!!! Thank you so much!!! 😃

[@599CD]

Hope I didn't hurt ya too bad. :) You're welcome.

[@johndelacruz9561]

Great video. Thanks for sharing your knowledge.

[@599CD]

Welcome

[@xm_tech]

Oh man that's a life saver. Thanks for sharing.

[@599CD]

Welcome

[@jtflypegasus]

My man, you're a MSAccess wizard 👍(I enjoyed your presentation)

[@599CD]

Thanks

[@samobenedicic3051]

I've been watching your videos for a long time now. Extremely good, easy to understand. One question, though. At 18:06 you clear those textboxes with empty strings. Would it better to use "Null" when clearing textboxes? Empty strings gave me some trouble when I moved to SQL back end.

[@599CD]

Yeah, SQL does tend to prefer NULL. In Access, I prefer using empty strings.

[@johnsonofjohn1678]

You're a life saver!

[@antoniolelio6953]

Very good! I like it!!! I am from Brazil, I am training to learning Microsoft Access! I am Microsoft Office Specialist Excel (MOS)

[@599CD]

Nice to meet you. I'm in Florida. Always wanted to visit Brazil. :)

[@rhaebus9785]

First off Great Videos, these have helped me build a usable database for my work that help us coordinate and track almost everything in our department. I've been adding more features as the database grows and am completely stumped on one task I would like the database to do. I'm trying to figure out a way to do a anti-search of sorts. I want to know what employees have not attended a class for instance. I can get a query to return students that have been to a certain class, say Supervisor Class, but when I try to figure out who has not been to the Supervisor class it'll still bring up people that have been due to the fact that they attended other classes as well. Been racking my brain over this for about two weeks now but google searches and videos have come up empty. I feel the solution is super simple and it'll make total sense once I see it, but as of now it's just out of grasp. For example in your sample database it would be like to find all the customers that have not ordered a certain product. Doing a simple order query would still bring up people that have ordered the product due to them ordering other products and the query will list them multiple times for all the products that they did order. About ready to abandon this and just export everything to an excel document and search that way, so you and KZbin commenters are my final hope :)

[@599CD]

It's funny you ask this because I've got a video on this topic coming up very soon! One of my members asked something very similar. Stay tuned. Don't give up.

[@jimkranz2181]

This is great. Love your videos.

[@599CD]

Thanks so much!

[@rafaelhernandez5949]

This is the best and ease learning Thank you

[@599CD]

Welcome

[@csl2063]

I used to use Access a lot for work and knew most of this stuff, but haven't used it for about 20 years. I'm now re-learning it just for personal use (because I'm a geek), and your videos are amazingly clear and helpful. I had a lot of yes/no fields in my main table and I've now gone and changed them to a separate table (and join table) where I can add tags at will, with a subform. Can you point me to a video that will help with doing searches using fields on the main form AND the subform, please?

[@599CD]

599cd.com/Ask - and thank you for your compliments

[@shahinulkhan7879]

Great video once again. You don’t have a video showing how to put a simple search box into a form to do a live search for a record of the same name like the box at the bottom of access? Would be much appreciated Thanks a lot.

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@moodkn]

Thanks! very high

[@599CD]

You're welcome!

[@kalpeshsangita]

Thank you for the great tutorials. I am following your instructions but it is not working in my template because I have combo boxes for the field that I am trying to search

[@599CD]

Yeah, that adds a level of complexity to it. 599cd.com/SearchSeminar

[@rabidfollower]

In my app, I use just one search box to search all fields all at once. That saves the user time of having to type in multiple boxes. Searching "francis" will return names, cities (San Francisco), etc. that has that word. Yes, the query is more complicated, but it would be a nice teaching moment for your students: e.g. Select * From Customers Where Instr(1, FirstName, 'francis')0 Or Instr(1, LastName, 'francis')0 Or Instr(1, StreetAddress, 'francis')0 ...

[@599CD]

Yep. I cover that in my Search Seminar: 599cd.com/SearchSeminar

[@andrewmetcalfe7748]

Great video and love watching. Have you do a multi search that updates as you type. But with tick boxes of different categories. For example: inventory Categories 1. Electrical goods 2. Plumbing items 3. Stationary Ok a short list of three but if ticked category 2 for example You have auto update search for part numbers as wildcard that contains part on the number but only in categories2 Or you do only search to what ever is ticked. If none ticked then search in all . If you know what I mean

[@599CD]

I cover "search as you type" in my Search Seminar. Adding the check boxes would be simple too with the techniques I show there. 599cd.com/SearchSeminar

[@juanosorio8613]

Helped a lot for work, 1 question though. What can I do so that the user can still type in the search boxes, but not edit the records

[@peaches6699]

Thanks!

[@599CD]

Thank you very much. I appreciate that. :)

[@nap1030]

Gear video. It was very helpful.

[@599CD]

Thanks

[@edwardsapu2032]

Enjoy and make me learn a lot

[@599CD]

Thanks

[@FlashGormless]

Hi Richard, I'm loving your tutorials learning a lot! I have a question though, I've done this lesson 3 time now with the same results, it works brilliantly as a single form but if you use this form as a subform it pops up a msgbox asking for parameters on the FirstName and LastName Search fields? I've cheked all named objects to see if it was a fault there but no can't find the problem, Any ideas?

[@599CD]

Yeah, this wasn't designed to be used with a subform. It will require you to understand how to reference fields on a subform. I would recommend putting the search boxes in the form header of the subform, and then you won't need to worry about that. Don't put the search boxes in the parent form; the whole lot will be easier that way.

[@dominicmongis1125]

Hi Richard. I keep getting stuck in similar places. I created a "customer table" this stores customer info such as first name etc. I then create a second table which stores info on their shortterm policies. I don't recreate "first name, last name" as you have often mentioned bot duplicating info. So the two tables link by means of an ID. So on the "policy table" when i open the form I managed to get it to show the clients "first name, last name" however in the table itself it stores the link as a number. So now when I try and include a search button the field has the client "ID" which is a number and not a name. How do I get around that? Thanks for all the great lessons. Dominic - Silver Member from South Africa

[@phillipbader4144]

This video was extremely helpful recently, my work wanted me to find a way to search our inventory of certain items by different data points. My question is, i'm trying to publish this form so that anyone in my department can use one shared computer to search for the item they need, but most do not know how to use access. I cant figure out how to publish my form so anyone can use it and just see their results without using access, do you have a video on this? Thank you again!!!

[@599CD]

You could publish to the web: 599cd.com/AccessOnline Or a shared Excel or HTML file: 599cd.com/ExportHTML

[@rasheedmuhammad3599]

Excellent brother your are excellent teacher Allah bless you

[@599CD]

thanks

[@thedispatchke9128]

Your Tutorials are amazingly good. On this one, though, I don't understand what happens between minute 21.17 and 21.40. somebody explain.

[@BanditFX7]

Hello Mister Rost, it's very useful tips How to display a dialog window which proposes to automatically add a missing element of the search form in the table? To make data entry management more efficient.

[@599CD]

I don't understand. You can just type missing data right in the form.

[@markbruening2066]

Thanks for the videos you provide. I have a question. Can you add a form footer total for the "IsAvtive" When the Tri state check box is clicked. EX. Null/Yes/No. It would be cool if a form footer total would sum the value when each is checked. Thanks Update: I used this as the Control Source, Sum(IIf([IsActive],1,0)) ,In a Text Box in the form footer. Works Great

[@599CD]

You got it. :)

[@sweetpea4517]

Love your videos! I have a problem with the criteria in the Search Query. When I put in the criteria, it says "does not recognize '[Forms]![SearchF]![SearchBox]' as a valid field name of expression." I used the suggested fields so I'm not sure what I am doing wrong?

[@599CD]

Something is probably spelled wrong, or you have it in the wrong spot. It's impossible for me to tell without seeing your database. That's why I encourage my students to upload screen shots to my Forums. 599cd.com/AF

[@hazemabouloyoun5881]

Super ❤❤❤❤

[@timothystrom1105]

Great video! One question I discovered - in using the query as the record source for what would be CustomerListF, the Open Customer button no longer works. If I put the record source back to CustomerT, it works but then the Requery button does not. What’s the fix to get them both to work?

[@599CD]

Don't change the record source. CustomerT is coded into the SQL in the VBA. You'd have to change it there too.

[@timothystrom1105]

@@599CD Thank you for the reply! I'm building a vendor management database which is having the same issue. Looks like I'll just have to work my way through the SQL lessons! Greatly appreciate all of this instruction and content. I've been wanting to learn and utilize Access for numerous years, and couldn't until I started on your lessons. This is exceptional content, guidance, walkthroughs, and support, and very thankful you have built it all!

[@stevenlazo6771]

Hello Mr. Rost, Your video was very helpful and the continuous form is exactly what I needed to show all of my inventory. I do have a question though, I designed my SearchList form (called frmSearchList) almost identical to the way you designed your Customer List. In my query, I placed 5 fields. (PartNum - AutoNumber), (PartDescription - Short Text), (CategoryDesc - Short Text), (SubCategoryDescription- Short Text), and (Available_Inventory - Number). There are times where some of my items do not contain a SubCategoryDescription and are meant to stay blank. In my query i placed the criteria as Like "*" & [Forms]![frmSearchList]![txtSubCategory] & "*" Or Is Null. My frmSearchList form is not returning blank records. Do you know where I may have gone wrong?

[@599CD]

That should work. Post this on my web site in the Forums along with some screen shots of your design. We'll take a peek.

[@599CD]

599cd.com/AF

[@semondereje]

Thank you so much I tried and it works great for the firist time When I try it for the second time when I write "like" it is changed to "Alike" what should I do?

[@599CD]

599cd.com/a?10427

[@409demo]

Very informative. The problem I'm having though is when I load the form or clear the query I'd like to show the null fields but when I search the field I'd like to not show null. SO when I add "IS NOT NULL" it will load the continuous form with the blank fields and during my search criteria it will show null as well. When I run the criteria [Like "*" & [Forms]![MarList]![MirSearch] & "*"] on load or clear it will not display the null fields.

[@ah248-ty3xj]

Hi, did you ever figure out the solution to the problem? I am encountering the same issue as well.

[@kylewatson2298]

If I wanted a field to be exactly equal or be Null how would I enter that? I have [Form]![myform]![searchbox] Or is Null but that doesn't seem to work. Any suggestions? This is a combo box if that helps.

[@599CD]

599cd.com/Ask

[@mmd_k1995]

Hi there! Is that a way to 7sr a Ajax search in the access on which it will show the search result immediately as you type in the field and not pressing TAB button?

[@599CD]

Yeah, there's a Key Press event. 599cd.com/ACD8

[@Vegg17]

Hi what are you doing on 21.26? Which button are you pressing or typing so the all the tables are showing again? (In the VBA)

[@599CD]

599cd.com/QQ

[@SimplyAmazing247]

Hi! I’m working on converting an existing db to an online db. The problem I’m running in to is there is a multivalue field I use to search specific items. Is there any alternative way to doing this in an online database??

[@599CD]

Multivalue fields are evil. 599cd.com/Evil. You'll have to separate it out into a related table, like it should be. Online: 599cd.com/AccessOnline

[@ahmedjabbar5589]

Cant thank you enough.

[@599CD]

Welcome

[@Typeitproductions]

So I followed these steps and it worked great! Everything was working so I was making some design changes (Moving the positions of the fields, Box sizes, colors, ect.) I came back a few minutes later and now it has broken and is asking for parameter values every time I try to open the form or query. I haven't changed any of the names of the boxes and even used the expression builder to make sure everything was spelled correctly. I deleted everything and started from scratch and the same thing happened. It worked for a few minutes then went back to asking me for Parameter Values when opening the form or query. Its driving me nuts. Any idea what is going wrong?

[@Typeitproductions]

So literally seconds after posting this I found that in the code for the form there was an empty Private Sub that I mistakenly made after writing button code that I must have exited from. I deleted that and now everything works fine! I'll leave this up in case someone else somehow manages to accidentally produce this error

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@rudiaguswidono5450]

Excuse me, do your table's column width can be adjusted freely by user if the value of the field is too long to appear on the field? If you already covered this in the your other video, can you show the link? For the limitation of my database and user knowledge, i need to give the user some sort of way to adjust the column width like what you do on excel's column.

[@599CD]

The user cannot adjust them easily at runtime like in Excel. Sorry. You can edit the column widths property in the design.

[@599CD]

One of my members actually asked a similar question recently, so I'll be making a TechHelp video on this soon. I'll be showing how to do it with VBA in the Extended Cut.

[@mumbaitiger]

I guess it should still work if you put it one below the orhe other in criteria under Last name , State respectively instead of adding "OR NULL"

[@599CD]

Give it a try.

[@easyspeak101]

@RichardRost .. Im curious.Hope its not too intrusive. How did you learn all this where a lot just didnt? .. A lecturer at Uni sold me a computer .. when i opened i found a hidden application (not used), in either dos or files/folder.. about 2000ad..

[@599CD]

How did I learn what I know? Mostly books and trial 'n error. I've been an IT pro since 1994. 599cd.com/AboutRichard

[@easyspeak101]

Oh.. You definitely good at applying yourself to your findings . I'll have a read .. I find remembering this subject matter difficult even with practice.. it gets forgot.. Thx.. 😊

[@sjjs3189]

Please help! I followed your steps and everything worked exactly as intended with all my practice data, but with any new records added after I created this search box, they don't show up. They'll appear in the list when I open the search form, but the moment I hit Requery, or Clear Search, they disappear, even if nothing was entered. The Form load and clear search have the same exact code and the Requery button just doesn't have the Setdefault. Any idea what could be the issue?

[@599CD]

Can't tell from here. 599cd.com/Ask

[@lion_0077]

How to make search box as(while) we type at that time filter form(on that second filter form)??

[@janedougherty7439]

When I change my record source to the query I lose all my original data, which makes perfect sense to me, if I'm not pointing my form to the original table how can can the datafields be populated?

[@599CD]

Queries just show table data. Shouldn't matter.

[@osvaldocarmona1747]

Not sure if anyone has caught this but on the code builder for the clear search the line of code is FirstNameSearh = " " and so on. Had a person go in, type a letter and just click clear search and nothing would pupulate. They tried to put in a letter and nothing. I found that that is because " " is equivalent to a space. If you just do the code to be "", that solved it. Just wanted to say. Don't think it will happen often but just fyi

[@599CD]

Interesting. Thanks for sharing.

[@osvaldocarmona1747]

@@599CD no problem! Your videos have been extremely helpful! Thank you so much for all the hard work!

[@hethersettsrilankahetherse1726]

Hi sir, everything supporting to me. If you can please update menu costing formats like search, editing with summary

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@kediadinesh]

Sir How to manage font size of ms access report fields through other form. So user has right to change font size of report without opening report in design view in ms access.

[@599CD]

That's tricky, but I do have a video coming out on this subject soon. I'll be covering it in my Holiday Greeting Card Mailing List Seminar very soon. Watch my web site for it. 599cd.com

[@senorimotor]

This changes Like “*”& [EVERYTHING!!!]

[@599CD]

Haha Thanks

[@abdurrahmanalkalash4072]

THANKS FOR THE VIDEO HOW I CAN SEARCH FOR NUMERIC VALUES THAT I INSERT IN ONE SEARCH BOX IN MULTY COLUMNS LIKE WHEN I TYBE "R" IN "FIRST NAME" BOX IT SEARCH IN THE BOTH COLMUNS "FIRST NAME" AND "LAST NAME"

[@599CD]

For numbers, don't use quotes.

[@abdurrahmanalkalash4072]

@@599CD Ok but How i can search for the value from just one box in multi columns?

[@remcop1989]

So I’m looking for a way to immediately update the continuous form without leaving the record BUT at the same time store a value in a table. Is it possible at all? Reason is I have continuous form with products. But the total price in the form footer doesn’t update before leaving the record. And I do want it to.

[@599CD]

In the AfterUpdate event for each textbox, you'll need a Me.Refresh. See 599cd.com/AfterUpdate

[@599CD]

I cover this in my Invoicing lessons, but I've also had this on my list to make a TechHelp video about it, so stay tuned...

[@user-uu1ff7mw7l]

Is it possible to search multiple fields in one search box? say I want to search first name, last name, or state all from the same box.

[@599CD]

Sure you just got a code it that way. 599cd.com/EasySearchForm

[@bradburkham7817]

I'm wanting to hide the tables can these multifield searches be used on forms?

[@599CD]

Of course

[@tylerpatsula8805]

Do you know how to prevent parameter pop up box for each field search textbox when trying to add the search form to a navigation form?

[@599CD]

Use a form field. 599cd.com/FormName

[@tylerpatsula8805]

@@599CD I guess I wasn't quite clear when I originally asked the question. So I have multiple search forms which when opened individually work fine on their own however when I then try to put all of these forms onto a navigation form each search form upon selection from within the navigation form has an enter parameter value pop-up for each text box I use as a criteria for the search. Do you know how to prevent this?

[@599CD]

Yes. Use a form field instead of a query parameter, which is what is explained in that video I pointed you to.

[@tylerpatsula8805]

@@599CD I'm already using form fields and getting the enter parameters boxes that what's confusing

[@albyluchko6030]

@@tylerpatsula8805 Are you trying to put the forms with working search boxes into another form as subforms? I'm running into the same problem and I think it's because of the way the query is written. In his "bang v dot" video, he mentions towards the end about how to reference a subform versus a main form. I'm having the same problem and I think that's why. Did you manage to fix your problem?

[@panshulagunasekaran2819]

can this be used to search for customer phone numbers in the entire database?

[@599CD]

Sure

[@panshulagunasekaran2819]

@@599CD how can i do that?..im kinda new to access...

[@8deepak8sharma8]

After entering the first name search criteria in the query, when the query is run, a popup window appears which says Inter Parameter Value.

[@599CD]

599cd.com/epv

[@antoniolelio6953]

I am training to learning English too! rsrsr

[@599CD]

Awesome! Good luck!

[@danielsoltero9462]

CustomerListQ shows me all the records on customerF regardless if the searchbox is empty or filled.

[@599CD]

Then something is wrong. Try again.

[@vic902]

This is not working for me at all. Whenever I try to run the query it shows a blank page. I’ve tried everything. I’m not getting errors so I wonder what might be wrong?

[@599CD]

It's impossible for me to tell from here try posting this in the Forum and we'll take a look at it 599cd.com/AF

[@gonefishing2006]

I wish there was an easier way for me to remember the commands to that query search from a Subform.- I end up stabbing at it till I get it right.

[@599CD]

It just takes practice. You'll remember it eventually. I've tried making one of those "quick reference sheets" for Access, but there's no way to make it useful... if you put everything on the sheet that you need the font gets REAL small. :)

[@Heyhooves]

This method just is not working for me and I cannot figure out what I am doing. I went so far a making a similar simple database with no luck. I keep getting a pop-up asking for the perimeter. When I input the value in the search field, the perimeter pop-up comes up. Am I using an incorrect version of Access?

[@599CD]

599cd.com/EPV - I'll bet it's a typo

[@Heyhooves]

@@599CD Turns out I was searching for numbers instead of letters. Fixed that and I was able to perform the search using a City field with the query and the desired records showed up in the query. The records do not show up in the form. All records still are listed. I checked all the criteria, spellings and everything matches. I am at a loss.

[@Heyhooves]

I am having no luck in getting the form to requery. I can requery the query and it gives the results I ask for, but it does not go into the form. Frustrating.

[@mostafaeltarabishy8868]

how to search in two tables as i have 2 different customer list please help me

[@599CD]

599cd.com/UnionQuery

[@user-jo9de7xs9q]

How do I make a report based on these searches?

[@599CD]

That's going to be the video for next Tuesday (May 9) here: Filter Report: 599cd.com/FilterReport

[@waynedelaney5234]

This video was immensely helpful; until I got to the point where I type in the search box. I could not type anything in the box. I didn't even get a curser. I thought I followed the instructions to the letter. Where did I go wrong?

[@599CD]

Without seeing what you've got, it's hard to tell where you went wrong. If you can't even type in the text box, make sure it's not locked and you have Allow Edits set to yes.

[@sdecken2700]

Me too. I've rebuilt it twice and can't figure out why.

[@sdecken2700]

I figured it out. Really hard to find the properties button for the right part of the form. Just went through an O365 update and they keep changing things.

[@sashatz3387]

I have been trying this for a day or so. I have the LIKE "*" & Forms!ContinousForm!btm1& "*" or null. Same for a second btn. but it askes me for a parameter value(Forms.Shared with.Value) has anyone run into this issue before?

[@599CD]

599cd.com/EPV - probably spelling

[@sashatz3387]

@@599CD Thanks for the reply, I have checked the spelling a few times and it is correct. What are other things it might be?