Has anyone attempted to create a parameter query using a form with multiple fields. What I currently have is a form with say 20 fields. I would like to be able to run a query on a table that searches for user input in any of the fields on the form (sort of like the "Find" command). Below is sample code that works for multiple fields but the user input has to match the record(s) exactly.
Where (((table.field) Like '*' & [Forms]![queryform]![field] & '*')) AND ((table.field) Like '*' & [Forms]![queryform]![field] & '*'));
For example if the user is looking for a record that has a name field but the user isn't sure what the exact name is they would enter say "Rob" and the query would return all records with "Rob" in the field which may include "Rob", "Robert", "Roberta", "Strob" etc. Second say the user entered that same info in the name field but also entered info into say 5 more fields such as last name, birthdate, etc. I would want the query to return all records that 1) where like the entry in the name field 2) where like the entry in the last name field 3) where like the entry in the birthdate field etc.