Tweak SQL query to clean up and narrow down results

[mafhobb]

Ok, I understand the logic except for this:

strWhere = ... where clause of txt1 + txt2 here

For this line to work, I would need to add the Where for each combination of txtstring and each field right at this point, correct?

mafhobb

 

[vbaInet]

If strWhere was set before that line it means that txt1 must have set it. So, concatenate strWhere to the criteria for txt2.