Let me put it another way:
On form "SearchForm" you have 6 unbound text boxes and an unbound combo box.
Lets say you are entering characters in the text box named "txtname" (Surety Name).
The subform "SearchEN subform" (shouldn't use spaces in object names) has query "SearchEN" as the record source.
The field "Name_of_Surety" has a criteria of
Code:
Like "*" & [forms]![SearchForm]![txtname].[Text] & "*"
Because you are using the Change event, you get the "search as you type" action (you are referencing the TEXT property of the text box).
BUT, because each of the other field criteria are
also using the TEXT property, the search is only searching on the field (Name_of_Surety) that
currently has the focus.
Since the other unbound text boxes do not have the focus, there is
NOTHING to search on.
Because you reference the TEXT property of a control,
you will only be able to search on ONE field - which is based on the control that has the focus!!
It *might* be possible to create "search as you type" using code, but it would take
LOTS of code (maybe a couple hundred lines of code) to do it.
Sooo much easier to use the after update events and call Allen Browne's code.
Good luck with your project......