What does the code look like that generates your search results?

I dont get any search results at all. The only error message I get is the one in the picture, Can't Use
find or Replace.

Is it because the Salesman field is a Combo Box?

Search Form 2.0

I have done that, couldn't get it to work. It doesn't seem to want to search inside the Sub Form which is a continuous form. As I have said, it seems all I can do is make queries.

How is the search performed?

If it is done in VBA, show us.
If it is done in a Macro, show us.
If it is done in a Query, show us.

If we can't see what you are attempting we can't determine what you are doing wrong.

I gave up on search Salesman in favor of using Queries.
I have a Search Customer Name button which works. Getting back to the Form after the search is now a problem. I will include screenshots of what is happening now.
1-PreSearch,2-Aftersearch,3-AfterClearForm,4-AfterRequery.
To summarize, I had to make a Close Form button and then need to reopen the form to go to next new record. I am sorry to be so unfamiliar with what to do. I have watched so many videos it is sometimes hard to keep them all straight.

I rebuilt this form again from scratch instead of trying to fix my original one. Still have same issue of not being able to Refresh and or Requery the form to get to the next new record.

David, the guys are trying to help you, but you're not giving them enough information. Kevin said he needs you to show him what you're doing. We need to see your query in Design View. What VBA code are you using to refilter the subform? You're showing us meaningless screen shots.

I show you how to build a better search form in Access Advanced 6, and a much more enhanced one in Access Developer 26. I see you haven't taken any of my Developer lessons, so these will involve some VBA. Start with Access Developer 1.

Hello,
Sorry for the delay, I have under the weather for a while.
The only VBA code I am using in this form is this.
Private Sub Customer_Name_Click()
             Dim s As String
  
  s = InputBox("Enter Company Name", "Company Name", CompanyName)
  
  If s = "" Then Exit Sub
  
  Me.Filter = "CustomerName Like""*" & s & "*"""
  Me.FilterOn = True
End Sub

I will also include the query that I am using as a screen shot.
What the search is doing after you enter what you want to search for works just fine with all searches. What I can't get to work is a requery button, so I had to remove the button since it really wasn't working anyway. So now I am just using the
filtered/unfiltered button and the go to last record that way. It is no longer in the database, but it was just the me.requery  vba.
Thank you.

I wanted to originally to be able to search for part numbers the same way i can search customer name. I have used the same VBA code that i use only changing customer name to part number, but no matter what i do, it comes back as an error. Thats what i am using queries for those kind of searches.

This is what happens when I try to do a part number search:
Private Sub SearchPN_Click()
     Dim s As String
  
  s = InputBox("Enter Part Number", "Part Number", PartNumber)
  
  If s = "" Then Exit Sub

  
  Me.Filter = "Part Number Like""*" & s & "*"""
  Me.FilterOn = True
End Sub
Except the please enter part number.......
comes up yellow in the debugger dialog box, but i don't know where i've made the mistake.
Thats why I gave up on the part number search altogether and am now using the run query instead, they work just fine.

Does PartNumber contain a space?

In the Default Value for the Input Box you refer to "PartNumber", but in the filter you refer to "Part Number".

In my table, this is how it, I have Part Number Set: PartNumber, my form label is Part Number. I thought InputBox is like message box.

I don't know a better way to do the subform or as Richard would say, The Details Form(Quantity,Part Number ,Description ,Other Information ,Salesman). I tried to base My forms on the Invoicing forms Richard shows how to make, but obviously I am doing something wrong.

Is this not the way Richard says to build this kind of database?
See photos.

Try:

s = InputBox("Enter Part Number", "Part Number", Nz(PartNumber,""))