Before I write the code and beat my head against the wall trying to troubleshoot it if it doesn’t work… is it possible to write an access query that searches for a string in multiple columns for example.
SELECT * FROM table where COLUMN1 OR COLUMN2 OR COLUMN3 = ‘WHATEVER’