I have no troubles modifying a query to cater for my search criteria, but what if you want the user to be able to do it, ideally at a form level? Similar to the 'Find' button in a form, but I want to create a datasheet or tabular form containing only the records I want. The closest I've gotten so far to a neat interface is in the design view of the query, adding a non-existent field Expr1: [Search String] and then having [Search String] as the criteria for the field I want to search. When you open this form, it pops up 'Enter Parameter Value' Search String:, and typing the value concerned will do this.
But I think there has to be a better way. This method only seems to be able to return exact matches, regardless of where I insert wildcards, and 'Enter Parameter Value' isn't a 'neat' end-user term to display. How would I do this at form level?
But I think there has to be a better way. This method only seems to be able to return exact matches, regardless of where I insert wildcards, and 'Enter Parameter Value' isn't a 'neat' end-user term to display. How would I do this at form level?
