HI Everyone, I"m not quite sure how to do a multi field search with a single search box and have the results in a list box. I would think the it would probably have something to do with using an "or" query, but I'm not quite sure how to set that up with the query builder.
I already have a single field search with a list box for the results using a query with Like "*" & [Form]![SearchForm]![SearchTxt] & "*". I would like to know how to get the list to auto requery as you type in the search box but I haven't figured it out yet.
Also thank you to PBaldy for putting me on the right track with VBA to be able to set the list box up to allow someone to double click the item to open a form to that entry.