Search box (1 Viewer)

[ankrumc]

I'm curious if I can can create a search box that would bring back any record that contains the search entry. For instance,

I enter "fish" into a text box on a form. (I'm pretty sure that needs to populate somehow in a query, but the results I would want would come from every field from every record)

I get a report that brings up every ID/name that had "fish" in any of that records fields i.e.

35 John Glen Pro Fisherman (under occupation)
51 Steve Buchemmi Fish Tacos (Favorite food)
79 Susan Lucci 21 Fish street (Address)

I hope that makes sense. I remember seeing a while back on a page a simple command that may have done that, but I can't find/remember it.

Thanks for all help!

 

[John Big Booty]

Check out the cool Search tool here.