I have a data entry form and would like to create a field on that form and allow the user to enter a string of characters and then click a command button that will then display all of the records that have that string of characters in either the name field, (txtName), OR address field, (txtStreetAddress).
I understand that it is possible that more than one record will be displayed but that is ok.
In other words, if for example there is a record with John Doe in the txtName field and the user enters "Doe" in the search field and clicks the command button, then that records would be displayed. If there is a Jane Doe and a John Doe, then both records would be filtered and displayed.
What would the code look like to do this?