Posted on 2014-12-02
I am looking for advice. I have a table with 125 fields believe it or not. It comes from an Excel file import. I need to create a way to allow the user to search from data records in any of the fields. In the past I've just created a form with fields to search by and then created a query with those fields and then for the criteria for each field I've used, for example:
Like "*" & Forms!frmName!txtField1 & "*"
Is there a better way? We want to be able to search on any of the fields or any combination of the fields. But a form with 125 fields to search by?????