& - is this your code or did the forum inject those? AFAIK, that's html and doesn't belong in a vba line of code as a rule. (as I moved through, I realize it's not the forum).
ok first the whole thing is wrapped in quotes - no, it's not. If it was it would look something like this
"""[" & fldName & "] Like '*" & SrchVal & "*'""
I think brackets are used in case there is a space in the name - True, or worse, begins with a number.
when why are () used - Several reasons. When a function returns a value, the parameters need to be enclosed. When you want to group AND's and/or OR's. When you nest functions; etc.
do we always wrap the concatenated values individually i.e. & something & & something else & - that's not wrapping and it's not the right syntax. Concatenation can be tricky, but I wouldn't use &, just &. Best you research some examples to get a feel for it. Try Google?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.