IMO you're going to have to use vba to build criteria using LIKE operator. If the other form fields are going to have search terms, then this code would build the criteria like:
"LIKE '*'" & Forms!frmMyForm.txtNameHere1 & "'*' OR LIKE '*'" & Forms!frmMyForm.txtNameHere2 & "'*' OR LIKE '*'" & Forms!frmMyForm.txtNameHere3
assuming it is an OR situation and not an AND situation. Also, that is an example of a build where all 3 contain values. If not, the form field references would change accordingly.
Alternatively you can do this with a query, but AFAIK, you will have to reference each control 2x - once for when it contains a value and one for when it is null, thus a very long criteria with 6 references for 3 fields.
Or perhaps a messy nested IIF which will be about a yard long, so my least favourite. No doubt my syntax is not correct in the example - probably some misplaced/missing quotes.
Also see http://allenbrowne.com/ser-62.html
Last edited by Micron; 07-20-2021 at 02:36 PM.
Reason: added comment & link
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.