Search results

Hey John, Thanks for the welcome and advice. I don't think the linked example is what I'm looking for, as the query is still using the Or criteria to search multiple fields. I'm trying to figure out if it's possible to first combine the fields into one, to then have a single Criteria, as the...

Hello, Is there a quick way to have a search value (Like [Forms]![Report Form]![UICodeTextBox]) look for a match in two fields (Code A, Code B)? I've tried using the Or criteria option, but as I have many searches on the form, which only lookup one field, it seems to dramatically slow down...