I am assuming you have a Sub Routine that handles the search. Have you called that Sub in the After Update event of your search fields?

Yes, I first copied in all the code in step 4 which I understand to be the actual search code.  I then put in the "ChangeFilter" in the AfterUpdate for each of the individual search boxes.  And the search box titles have all been name with the appropriate "Filter" tag.

I have noticed that every time I put in the following line "    If WhereStr <> "" Then WhereStr = WhereStr & " " & AndOrCombo & " "
    WhereStr = WhereStr & S", it changes the AndOrCombo to ANDORCOMBO.  Not sure if that is an issue or not.

Message Box the SQL at the bottom of the sub. This will show you the SQL statement that is being built.
You may have simply missed a space. That has happened to me in the past.

Thank you Kevin,

First which sub should I put the message box in?  Would that be for after update event or in the initial search code?  Also what is the command to message box the sql.  I know Richard covered that in one of the videos that I watched early on but I've not used it since.

At the end of the search code.

if the variable is mySQL
    MsgBox mySQL

MsgBox

I placed it right before the "End Sub" and it came back with a VBA error, "Compile Error: Variable Not Defined"

What is the variable you are using? mySQL was just an example.

Just downloaded the Template to have a look. It looks like the variable is S.

Private Sub RequeryForm()
    
    Dim S As String
    
    ' errorhandling code
    
    S = "SELECT * FROM CustomerT"
    ' other code
    Me.RecordSource = S

    MsgBox S
    
End Sub

I like to also add a space to the end of the SQL statement (S)
    S = "SELECT * FROM CustomerT "

Thank you Kevin,

That did send back an error for me.  I'm having this use my TestEquipt table.  I added the msgbox as you kindly showed me.  

Private Sub RequeryForm()
    
    Dim S As String
    
    ' errorhandling code
    
    S = "SELECT * FROM TestEquipt"
    ' other code
    Me.RecordSource = S

    MsgBox S
    
End Sub

I saved the code, saved the form, closed the form, and reopened.  As soon as I clicked on the button to open the form, I got a message box stating "Select * from TestEquipt ORDER BY NOT IsNull(TestEquipID), TestEquipID.  The TestEquipID is my autonumber (primary key) field.  There is always a value in that field.

Yes. That's what was expected. What does it say when you filter the form?

I entered a number "3" in the search box as I do have an ID 3 in that table.  It came back with "Select * from TestEquipt=3 ORDER BY NOT IsNull(TestEquipID), TestEquipID

It's not getting the WHERE condition (WhereStr).
Check the ChangeFilter Sub.
Also check the names of your search fields. Do they have the correct suffix?

Kevin, I double checked that all the names were right, and I recopied and pasted the If WherStr line from that sub and it worked.  Thank you so much for all of your help.  I greatly appreciate it!

Bryan

You're welcome. Glad you got it fixed :)